SQL Server Performance Forum – Threads Archive
Importance of the parameters in performance trace
Dear DB experts.. I need to know how this parameter affects the performance of SQL server. When a table has no column level and row level lock specified, do we have to consider the table lock escalations parameter into account?? If so why. I have set up a trace using this counter on a database with no such locks.. But still i am getting non zero values ranging from 0.008 to o.58. How should i treat this case and what sort of importance i need to pay for this??? The total average weight time for locks also ranges from 0.08 to 3801.8 per second. Kindly throw some light on this.
Check whether your database and environment falls under this KBAhttp://support.microsoft.com/kb/920206 information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.