August 4, 2017 at 12:32 am
We find CPU utilization reached to 100% last night. Client could not able to access database server couple of hours .
How to find what are the queries running on database during that period?
Thanks
Krishna.
August 4, 2017 at 1:03 am
krishna83 - Friday, August 4, 2017 12:32 AMWe find CPU utilization reached to 100% last night. Client could not able to access database server couple of hours .How to find what are the queries running on database during that period?
Thanks
Krishna.
Do you use any monitoring tools for your databases that allow you to view historical data or failing that do you capture any performance stats?
Thanks
August 4, 2017 at 1:26 am
krishna83 - Friday, August 4, 2017 12:32 AMWe find CPU utilization reached to 100% last night. Client could not able to access database server couple of hours .How to find what are the queries running on database during that period?
Look at your monitoring tools/custom extended events sessions and see what they recorded.
If you don't have any, then that information is not obtainable. SQL doesn't recorded it automatically.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 4, 2017 at 1:30 am
We do not installed any monitoring tools for SQL server database.
Can you please suggest any monitoring tools, At least these tools will help when I have a situation like this.
Thanks
Krishna.
August 4, 2017 at 1:33 am
krishna83 - Friday, August 4, 2017 1:30 AMWe do not installed any monitoring tools for SQL server database.
Can you please suggest any monitoring tools, At least these tools will help when I have a situation like this.Thanks
Krishna.
There are many available and it really depends on your budget. I use Spotlight and I'm very happy with it but there are also products by Redgate, Idera, SolarWinds and many others. They will all offer a free trial so try a few of them out and see which you prefer and fits into your budget.
Thanks
August 4, 2017 at 3:56 am
krishna83 - Friday, August 4, 2017 1:30 AMWe do not installed any monitoring tools for SQL server database.
Can you please suggest any monitoring tools, At least these tools will help when I have a situation like this.Thanks
Krishna.
As an alternative, you can capture the output of Adam Machanic's Who Is Active to a table, say every 5 minutes.
Here's how you can:
https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/
https://thomaspullen.wordpress.com/2011/04/04/session-capture-system/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply