今天有朋友让我帮看下其SQL Server Profiler的结果，如下图，通过观测其个性能参数发现SQL Server没有大的负荷；但是仍告诉我系统32G系统的服务器运行速度还是非常的慢，最后告诉她检查下系统的processes and the status of locks, and found the status was working fine, but said the speed of the server was extreme slowly , per my exeperience, it should be some setting incorrectly, finally checked the memoery setting of SQL server is not correct, after change and restart it seems ok.

 

Aims: 

1. learning to know about the meaning of different parameters of  SQL server, and please inquire the measurement  unit for  the paratmeters.

2. Many factors result in the bad performance in SQL Server, so we need to find it in different aspects.