Inconsistency in SQL Server performancegreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Hi Eric, Here in sql server performance sometimes we face here inconsistence behaviour. suddenly its going down and after 3 to 5 mins it comes up. when i see the process activity i found many process in sleeping state. in one process the following query occurs,
select c.encrypted from dbo.syscomments c where c.id = object_id(N'[dbo].[Admin_getPendingRequests_SP]')
many process which is in sleeping state has same sort of queries but differs in stored procedure names.
What is the solution for this inconsitency
Regards, Raja V
-- Anonymous, April 18, 2003
There must be something more to the story here. The syscomments table has a clustered index on the id. There is no way that the execution of that query is a performance bottleneck.
Hope this helps,
-- Anonymous, April 19, 2003