What are some good performance monitor counters to look at, when trying to figure out how "busy" our SQL 2008 server is? We were told to look at:
SQLServer: SQL Statistics: Batch Requests/Sec and SQLServer: Databases: Transaction/Sec . Any other critical ones?
Is there a counter to get the number of selects, updates, and deletes independently per second? Thanks.
View Complete Post