Counters in SQL Server ?

[kumar bs]

Hi, What are counters in SQL Server. And its significance? bsk

[Frank Kerrigan]

Counts allow you monitor the performance of SQL server and tune your server and schema for better performance. Look where you want to go not where you don't want to crash. Bikers Bible

[kumar bs]

What is the significance of Counters in Replication (SQL Server)? bsk

[Kevin Horgan]

Hi Kumar, SQL Server has about 150 different counters which can be enabled to measure system (database) performance. You can get lots of information regarding performancing monitoring and tuning including using counters at : www.sql-server-performance.com for example. You set counters to measure things like page faults per second or user connections etc etc Cheers, Kevin