性能对象                                       计数器名称                                含义及与实际问题的联系

SQL Server Access Methods                              Page Splits/sec                           每秒钟分页次数。超过100可以视为较大，将使得磁盘I/O变大

                                                                                                                      搜索变慢，性能变差。可以通过增大填充因子减少

SQL Server：SQL Statistics                            Batch Requests/sec                        每秒钟批次请求数量。是描述SQLServer是否忙碌的标准之一。

                                                                                                                      超过1000到5000可以视为较大。会影响网卡或者更换更高级

                                                                                                                      别的网卡解决

SQL Server：SQL Statistics                           SQL Compilations/sec                       每秒钟SQL语句编译数量。超过100可以视为较大。会影响查询

                                                                                                                       性能可以通过增加预先编译好的存储过程来提高速度

SQL Server General Statistics                       User Connections                               当前所有用户连接数。可以用来进行数据同比等，比如描述一

                                                                                                                        天中数据库用户的变化规律。通过增加硬件提高用户连接数

SQL Server Locks                                       Number of Deadlocks/sec                     每秒死锁的数量。需要SQL Profiler来进一步分析代码中死锁可

                                                                                                                         能发生的原因

SQL Server Locks                                     Average Wait Time(ms)                          平均锁等待时间。时间较长可导致用户提交数据更改时需要长

                                                                                                                          时间才能完成。对于一百万行数据的表，超过500ms的锁等待

                                                                                                                          时间可以视为较大

SQL Server Access Methods                    Full Scans/sec                                           每秒全表遍历次数。对于查询、全表遍历一般是比索引查询更

                                                                                                                           费时间的。对表应用合适的索引可以减少全表遍历

SQL Server Memory Manager                 Total Server Memory(KB)                             SQL Server使用的全部内存。尽量将数据库服务器的内存交给

                                                                                                                            SQL Server 使用