Do you have lock pages in memory enabled? No

Are there other applications running on this server? Just 2005

Is SSIS utilized on this server? No

Is CLR in use on this server?...

24 GBs total. Do you have the KB article number for the hotfix?

max server memory (MB)16214748364721474836472147483647

Pardon for my ignorance but what do you mean by batch?

Bouncing the server actually did improve performance significantly. Doesn't make sense to me. The process of rollback/killing was dragging the system to its knees and the percentage of completion was...

the restart worked. thanks.

Thanks. I found it was an indexing problem with their app. All is good now.

Did they specifically mention what type of errors?

I followed Steve's instructions up top and I was getting about 2 million deletes an hour (8 way 12 GBs ram on a SAN). Looking back, I probably should have...

Thats what I thought. Thanks for your response.

Thanks for all your help!!! Performance is back to normal.

Oddly enough, I still can't connect using <server ip>,1433 nor can I telnet into the server using port 1433 but........ after a restart, the client connections from the TSs are...

I am not much of an IP guru so I am not sure what I am looking for. The only local address I see running on port 1433 is... 127.0.0.1:1433...

Thanks for the reply Colin. With that being said, do you have any ideas as to why the slow down occured after I just enable an additional 3 GBs of...

Its a 2003 machine so this is what I have in the boot.ini  /noexecute=optout /fastdetect /PAE

Just for reporting. No one was on the system at the time of the restore.

We are certainly not a 24/7 shop. No one is on the system from the sunday backup to monday morning. No way I would expect 13 GBs of changed data....