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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2004-10-25 : 23:43:40
|
| I'm experiencing some wierd problems with so far unpredictable patterns. When my webserver tries to connect to my database server all connections are timing out. This just appears to happen without reason after running fine for hours.Is there any troubleshooting I can do on the SQL server side? I'm trying to investigate whether its a possible network issue but we are having problems confirming that.Any help is greatly appreciated. We are down right now ;(ThxMike123 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-26 : 00:04:59
|
| Could be something blocking on the server and preventing anything happenning.Put this in master and run it when it happenshttp://www.nigelrivett.net/sp_nrinfo.htmlIt's worthwhile running it anyway to see what is happenning on your server.==========================================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. |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-10-26 : 00:15:04
|
| Hi nr,I did what you suggested. It brought back about 100 records, the great majority where all selecting the same SPROC. Which is a SPROC that is run only on the first page view of the web application.About 80% are in "rollback" status as well.Does this mean anything?Thank you VERY MUCH, desperate for any leads right now.mike123 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-26 : 00:50:54
|
| Search Engine maybe (no cookies, so every page request will look like a new session)Some little blighter with a port scanner trying all combinations of SA/ADMIN password? (turn on Failed Logins in Enterprise Manager and see if the logs fill up like billyoKristen |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-10-26 : 01:07:34
|
| I think I found it due to running the SPROC NR suggested....... some very poorly designed SPROC that has been runnign only every 6 hours for the past three years3 years ago it was moving 5000 records into a temp table..... now its doing 250,000 and I believe thats what may have caused it...thanks alot guys! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-26 : 01:20:06
|
Not this one is it?SELECT *INTO #MyTempTableFROM MyRealTableDELETE FROM #MyTempTable WHERE MyPK <> @WhatIWantSELECT * FROM #MyTempTable Kristen |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-10-26 : 03:06:02
|
| lol thats hilarious |
|
|
|
|
|
|
Problem with connections timing out randomly