August 28, 2012 at 3:14 pm
I have a DB that I can run basic queries (albeit much slower than normal) off of. When I try to see the hierarchy trees for tables, views, or procedures in SSMS Object Explorer, I get the "lock request time out period exceeded". My Report Server reports that run off of objects in this DB are no longer completing. Jobs associated with procedures stored on this DB also do not run. I tried using sp_who2 to find and kill all connections on the DB. This has not solved the problem. What is going on here? How can I resolve this?
August 28, 2012 at 3:21 pm
you are likely running low on resources - disk, cpu or memory. Check resource monitor or performance monitor.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 28, 2012 at 3:27 pm
It's not a hardware issue. The server cluster hosts multiple databases. This is the only database having problems
August 28, 2012 at 3:30 pm
Like I said, you are most likely running low on resources - even for just this database.
What besides who2 have you done to troubleshoot?
What is the maintenance that you run on this database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 28, 2012 at 3:36 pm
How do you check if a particular DB is running low on resources?
August 28, 2012 at 3:38 pm
Does this have anything to do with your restore database thread?
Could there be something going on between these?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply