I am running UPDATE STATISTICS on one of my databases, it has been running for two days now, that is because one of the table is 22 million rows. Because it is still running all the users are experiencing slowness. It is process ID 99 how would I kill this process. I have already tried to right click and kill the process but it only stops for a while then starts again. Help Scrub
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cannot KILL UPDATE STATISTICS?
- Thread starter Scruby
- Start date
The Windows NT Resource Kits, both NT4 and Windows 2000 Professional, include a remote kill process commandline utility rkill.exe . To be able to kill a process or processes running on a remote server, you must have admin privileges and the rkillsrv.exe service must be installed and running. There is also a gui version of the client tool, wrkill. Please bear in mind that if you are killing the process and it is restarting it is probably restarting the update stats which could be why it's been running for 2 days.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question