Newbie so please bare with me.
So there's a sql server 2000 which caused some issues yesterday.
There was a spike of lock wait in the front end by what I believe was caused by a user presumably running a report.
The only problem is the server went ballistic and there was an insufficient memory available notification that came through, in order to quickly resolve this I had to restart the whole SQL server service.
Now my question is where can I find what query caused the lock wait since I'm not familiar with sql 2000, I tried to use foglight but it didn't give me no actual information because it doesn't seem to fully support SQL 2000, and in the window event viewer the only logs I get are the "insufficient memory available".
Since I had to restart the server, is there a specific table where I may find this information?
Any help in the right direction would be appreciated.
Let me know if I've been clear enough
To know where you're heading, you gotta know where you been :alien: