January 11, 2012 at 2:03 pm
Oracle linked server? Hmmm...
How is the provider loaded? In process or out of process? In process load could definitely crash the service if the provider leaks memory.
Even if regular connections are "frozen", you should still be able to connect with DAC, which has a dedicated worker thread. Have you tried investigating things from there?
-- Gianluca Sartori
January 11, 2012 at 2:03 pm
- the trc files you see are the ones generated because the default trace is active (+_ 20MB each, wright ?) I presume.
( please let it be active. It can help out with some kinds of root cause analysis ! )
- did you configure tempdb / reportserver_tempdb large enough to handle your requests ?
- Adam Machanics WhoIsActive procedure can help you very good trying to figure out who/what is causing real time blocking, .. http://sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspx
- I would start a trace at the time you expect problems to occur. Don't make this trace to heavy because you know your server is already suffering. Let it run for a reference period of time.
and work from there on.
- With linked servers, that may indeed be a pitfall, but that also needs to be investigated.
- check your databases for missing indexes, double check your objects are well maintained so they are in optimal shape to be consumed.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply