SQL Server Performance Monitor
Hi
we have SQL 2008 run on win2008, we need to monitor the SQL Performance, which counters i should use for monitor Memory, CPU,Hard disk and network. the key is, is there any base line after i get the result.
In the resource monitor, the disk I/O is 103 MB/S, the image is SQL.exe, how to know why the SQL use 103MB disk I/O /S ?
the Memory of Sql.exe is 23G used, how to know which database use it, we have 80 database in this SQL instance.
we have SQL 2008 run on win2008, we need to monitor the SQL Performance, which counters i should use for monitor Memory, CPU,Hard disk and network. the key is, is there any base line after i get the result.
In the resource monitor, the disk I/O is 103 MB/S, the image is SQL.exe, how to know why the SQL use 103MB disk I/O /S ?
the Memory of Sql.exe is 23G used, how to know which database use it, we have 80 database in this SQL instance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi i run the DMVs and get the result as attachment, what does mean for this result? how to know how many memory used for each database? i did not find any script in http://technet.microsoft.com/en-us/library/bb838723(v=office.12).aspx
memory.jpg
memory.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you, both is working, one more quesiton, what is different with plan cache and data cache?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you PadawanDBA
ASKER
Resource-Monitor.jpg