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 |
|
bilencekic
Posting Yak Master
121 Posts |
 Posted - 2006-09-24 : 10:11:12
|
| hi,On our server we have a performance problem.The server works perfect sometimes but, sometimes it slows down very very mucha query that returns in 0,06 seconds becomes to return in 15 secondswhen it is 0,06 i run the sp_who query and i see that 200-400 conenctionsbut when the queries becomes to return in 15 seconds i run the sp_who query and it shows me 700 connectionsproblem is conenction i think.what do you think ? what to do ?our server is a forum server that has 150.000 users.MS BLESS US |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-24 : 13:05:27
|
| It sounds lile something is either blocking or slowing everything down.The extra connections are probably due to everything being slow and are a symptom rather than a cause.I'm writing an article on just this sort of problem. You need to look at blocking and resource intensive spids.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bilencekic
Posting Yak Master
121 Posts |
Posted - 2006-09-24 : 18:28:28
|
| i fixed it by working hard on lock tips =)MS BLESS US |
|
|
|
|
|
|
sp_who