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.
Author |
Topic |
fazle_rabbee
Yak Posting Veteran
63 Posts |
Posted - 2009-02-09 : 08:47:45
|
I have got a publisher with 76 gb and Eight subcribers. From last 2 or 3 days, Its creating heavy problems. More then 70 pcs are connected with the server pc and are being used as client. Most of the time, after running 5 or 10 minutes very smoothly, the software becomes very very slow. In that time it works very slowly and often gives 'timedout expierd' error. Please tell me what could be the issue of this problem and how could it be solved. Please its urgent. Help is needed. fazle rabbee |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-09 : 09:02:46
|
Run traces to find out what is causing the issue. First have a look at which process is causing the issue, if it is SQL Server, then run a SQL Profiler trace and you can see what statement is causing the problems. |
|
|
|
|
|