Hi All, Iam new to the sql-server performance topic, i like to know the recomended values for the sql-server counter? Could any let me know. Thanks Koteswar Rao.Y
There is nothing carved on a stone that such and such values dictate a better performance of your database server, you have to perform a baseline and benchmarking exercise to identify how your server is responding to provide the resources. http://sqlserver-qa.net/blogs/perftune/archive/2007/12/19/2981.aspx is the starting point to performing above tasks.