Good Day Experts!
I hope you can lend some insight. We have SQL Server 2000 running on our server(I know I know). The problem of late is very sluggish performance. It could be performing acceptable but then the next hour it is like something is choking the life out of it. We have about 45 Users at any time using a VB6 app with this server as the backend. The Users could be doing anything from DataEntry to doing a lookup to running daily functions against a DB.
I have looked around on the net and tried a few things looking for the performance issue...but they were not very friendly.
Is there anything simple that I can run in QryAnalyzer, when performance is sluggish, to tell me which app, user, connections etc are causing the issue?