SQL Server Performance Monitor
Posted on 2013-11-25
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.