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 |
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-08 : 05:26:18
|
Welcome to a brand new set of problems that you are ill-equipped to solve  I can't terminate any crashed app in Task manager on any of my Win-7-Pro PCs, for example. So I now have to hard boot (usually power-off) at least once a day, whereas it used to be once or twice a month when everything got seriously clagged up.Thus due to teh frequency of reboot I now need a macro to reopen Query Analyser windows at start up just how I like them (first one must be connected to DEV Server/DB, second one must load TEST.SQL which is a safe BeginTrans/Rollback window for adhoc queries that can't screw up a live DB by accident, then I need windows onto each "surface" I'm likely to get asked to fix today ...)Damn! You've nodded off again ... |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-08 : 05:54:15
|
| Kristen.Have you tried process explorer: It's pretty sweet. No experience of it on windows 7 though.http://technet.microsoft.com/en-us/sysinternals/default.aspxI have to kill a checkpoint service regularly when it screws up and I can't access any of the live clients any mote. Process explorer + services.msc and I'm back up and running in about 25 seconds.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-08 : 06:58:18
|
| I'm a fan of sysinternals, I'll give it a go; thanks. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-08 : 07:11:46
|
| Installed, looks sweet!, will report back next time I have to kill something.psKill may be useful too : http://technet.microsoft.com/en-us/sysinternals/bb896683.aspx |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
L412