What is SQL Server: Statistics object?

The SQL Server: Statistics object is used to monitor the performance of a database. The counters of this object monitor the compilations, recompilations and batch requests of SQL statements. The recompilation of a statement can be caused by changes in a schema, insert, update, and delete operations, creation and deletion of objects, etc. A statement is recompiled if the schema of a database is changed, if data is inserted, updated, or deleted, if database objects are created or deleted. The recompilation of the statements results in slow performance of a database. The counters provided by this object are as follows:

• SQL Server: SQL Statistics: Batch Requests/sec: This counter monitors the number of batch requests received for execution. If the value of the counter is high, it indicates good throughput.
• SQL Server: SQL Statistics: SQL Compilations/sec: This counter indicates the number of times a SQL statement has been compiled. If the value of this counter is high, it results in slow performance of a database.
• SQL Server: SQL Statistics: SQL Recompilations/sec: This counter monitors the number of times a SQL statement has been recompiled. If the value of this counter is high, it results in slow performance of a database.

• Get certified in first attempt download mcitp - MCITP simulation.
• Best exam simulation Microsoft mcitp-database-administrator download free trial.
• Click here to get free mcitp-database-administrator-sql-server MCITP Database Administrator SQL Server exam practice questions.
• Get certified in first attempt download mcitp-database-admin-sql-server-2005 - MCITP Database Administrator SQL Server 2005 simulation.
• Best exam simulation Microsoft mcitp-sql-server download free trial.
• Download free practice test for mcp MCP exam.
• Download free practice test for Microsoft MCTS SQL Server 2005 exam.
• Pass SQL Server 2005 Optimizing and Maintaining in first attampt.
• Become Microsoft SQL Server 2005 Design certified.

• Previous Entry: Creating and Managing Database Objects through T-SQL Statements
• Next Entry: What is SQL Server Browser Service?