SQL Server having high RESOURCE_SEMAPHORE_QUERY_CO

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server having high RESOURCE_SEMAPHORE_QUERY_CO

Author

Topic

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-01-06 : 11:06:04

Hi,

I've read http://jefferytay.wordpress.com/2011/02/16/sql-server-having-high-resource_semaphore_query_compile-waits/

But I can't get a clear picture.

Hopefully, someone can elaborate with a better explanation

Really need help

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-06 : 11:23:08

Better explanation of what? What's your question, problem or concern?

--
Gail Shaw
SQL Server MVP

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-01-06 : 11:33:49

quote:
Originally posted by GilaMonster

Better explanation of what? What's your question, problem or concern?

--
Gail Shaw
SQL Server MVP

1. My concern is if I'm not do the appropriate steps, my SQL Server become slower day by day
2. My question is please tell me what's the appropriate solution need to be taken
3. Please recommend me the recommendation solution for above problem

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-06 : 12:06:23

No where near enough information to be able to help. You're going to have to give a lot, lot more if you want useful advice.

--
Gail Shaw
SQL Server MVP

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-01-06 : 20:35:08

tq Gail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources