Inconsistency in SQL Server performance

greenspun.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

Answers

Raja,

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,

Eric

-- Anonymous, April 19, 2003


Moderation questions? read the FAQ