I am trying to track down some abusive queries making MSSQL3 very slow, but not having a lot of success yet, I may hav eto reboot it here in the next 5 minutes at this point.
The server is still being slow as there is still major abuse by a user, however it is a bit more manageable for me to try to find the abuse now and I am working on it.
We are fixed up now, a server at another datacenter was connecting to the server very abusively after firewalling that IP out we are working great.
The server was not attacking, but using a legit connection, indeed 100's of them.