Performance Monitoring & Tuning

SQL Workload Analysis for SQL Server Data collection stopped, why?

State Not Answered
Replies 3 replies
Subscribers 149 subscribers
Views 4671 views
Users 0 members are here

Options

Related

Data collection stopped, why?

SherryCSpencer over 4 years ago

Why does workload analysis stop collecting data and display a ? in the first column of the grid called monitored instances?

0 Scott Stone over 4 years ago

You should probably open a support ticket as there is no specific valid reason to stop collecting. You may either have run out of space or started encountering an error (which could spin up extra processes and run out.) The ? just means you collected successfully at some time and have history but the latest collection didn't work.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 SherryCSpencer over 4 years ago in reply to Scott Stone

Thanks, i did open a ticket, but thought this might be a quicker avenue. Do you use workload analysis to support production environments, or do you work for Idera? because here is another question. how come the PostGreSQL database grows explosively?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Scott Stone over 4 years ago in reply to SherryCSpencer

Yes, I do work for IDERA.

Support should be able to help you decide if the growth is unexpected. (Have you checked the space requirements in online help?)

It samples queries rapidly for correlation and there is no aggregation to reduce space usage yet. So it should grow until grooming kicks in at about a month. Support can help you adjust that period if you want. It is documented in online help as well.

Support also can provide a manual script to clear history if space is a concern.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel