| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-09-22 : 09:35:35
|
| Hello All -Just this morning, our SQL server is experiencing very slow response time and every time we try openning "Management" the server freezes up. Any ideas guys ? No major update or patches installed... It's driving us nuts...Thanks!Igor. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-22 : 09:42:04
|
| are you trying to get to the current activity window?have you tried using sp_lock or sp_who from a remote machine in the query analyzer?have you ever heard of the Fonzy method? (kidding).====================================================Regards,Sean Roussyaka the merciless black hearted capitalist troublemaker"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-22 : 09:51:29
|
| No, I just got on the office and as usual, the first thing I look at is the Jobs, what ran and what not... We tried connecting from a remote using Enterprise Manager, but didn't try those SPs yet.Oh yeah, heard and used =D !Igor. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-22 : 10:55:25
|
| Same issue when I try to open "Databases". We still able to run queries on Query Analyzer and run DTSs...Igor. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-22 : 23:42:01
|
| Did you get this figured out igor?Look for active processes using sp_who that are using a lot of CPU.Also, you should be looking at performance monitor and profiler. I would hope you have it solved by now. lolMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-23 : 08:31:42
|
| We used sp_who and sp_lock, sp_who listed one process database/process in particular that continuosly takes memory (and on and on) and we're trying to take that DB offline. Do you guys happen to know what SP do I use to take DBs offline ? (if any)Other than that, we still having the same issue, I particularly think that the server can't handle as much I/O as it is having, but you know...Igor. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-23 : 09:20:41
|
| I got it...exec sp_dboption 'DB', 'Offline', 'True'Igor. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-23 : 11:50:45
|
| It worked, we ran the SQL Profiler, there is one DB which is taking too much memory (don't know why) and I took that DB offline using the command above, after that everything came back to normal. And life is beautiful for the rest of the day...Thanks for the help guys!!!!!Igor. |
|
|
|
|
SQL Server freezes when open "Management"