bubaibhatta
asked on
SQL Live Monitor
Hi All,
I have been assigned to maintain few SQL Server that are available in our VM environment. I searched in the internet and found a free application "SQL Live Monitor". I understand that this is basically a live display of different Perfmon counters.
Being a Citrix Administrator, I dont understand the significance of all the counters from SQL perspective. Can someone tell me which of them are really important and what action/ actions needs to be taken just in case if ther is some serious change in value happens.
Env:
OS: Windows 2003 Std.
SQL: SQL 2005
SQL-LIVE-Monitor.jpg
I have been assigned to maintain few SQL Server that are available in our VM environment. I searched in the internet and found a free application "SQL Live Monitor". I understand that this is basically a live display of different Perfmon counters.
Being a Citrix Administrator, I dont understand the significance of all the counters from SQL perspective. Can someone tell me which of them are really important and what action/ actions needs to be taken just in case if ther is some serious change in value happens.
Env:
OS: Windows 2003 Std.
SQL: SQL 2005
SQL-LIVE-Monitor.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Tony, this is exactly what I was asking for. This tool certainly is not the ultimate one but a basic indicator.
Being a system administrator I understand some part of it since they also included on my general performance checklist. Since I never worked on SQL server, I basically was trying to understand the prime counters and their significance. I googled a lot and collected lots of info. But I no where could find what are area that I need to concentrate when users complain me about slowness in SQL server.
Can you help me on that?
Being a system administrator I understand some part of it since they also included on my general performance checklist. Since I never worked on SQL server, I basically was trying to understand the prime counters and their significance. I googled a lot and collected lots of info. But I no where could find what are area that I need to concentrate when users complain me about slowness in SQL server.
Can you help me on that?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.idera.com/productssolutions/freetools