question

bmurali09 avatar image
bmurali09 asked

SQL Server Monitoring

Hi, I want to do the SQL Server Monitoring using t-sql query. Is it possible to get the monitoring data from sql server to excel. Please advise me how can I proceed with steps. Regards Murali
sql servermonitoring
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
0 Likes 0 ·

2 Answers

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
What is your goal? Live monitoring or collecting data for trend analysis? Several scripts are available (also on sqlservercentral.com) Have a look at these free monitoring tools: [databasehealth][1] or this one: [SQL performance monitor][2] [1]: http://databasehealth.com/ [2]: http://sqltouch.blogspot.nl/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bmurali09 avatar image bmurali09 commented ·
Live Monitoring
0 Likes 0 ·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
Try SQL Performance monitor
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.