Jimbo99999
asked on
SQL Server - Performance Very Sluggish
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?
Thanks,
jimbo99999
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?
Thanks,
jimbo99999
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Server Profiler was already available for SQL Server 2000. Did you try to run a trace to capture the locks and long running queries?
ASKER
Thank you for replying. I have not run anything yet. I am very light on this kind of debugging knowledge. I will try your suggestions.
ASKER
Thanks...I will read the article and work on this today.
ASKER
It is really bad today so I am going to have to try and figure something out.
jimbo, any feedback for us?
ASKER
Hello there...
We experienced it again this morning. I checked for locks. I am still searching for a way to tell me the connections at any given time using a query. I don't know when this is going to happen each time.
Thanks,
jimbo99999
We experienced it again this morning. I checked for locks. I am still searching for a way to tell me the connections at any given time using a query. I don't know when this is going to happen each time.
Thanks,
jimbo99999
You had the Profiler running?
Without the traces, only place you can check for some information is SQL Server log and Windows Event logs.
Without the traces, only place you can check for some information is SQL Server log and Windows Event logs.
ASKER
I did not have them running. I will start them today and see if we get lucky tomorrow.
Jimbo, any feedback for us?
ASKER
Hello There
We have been operating without any issues since my last posting. Do I just keep that trace window open and running until it happens again?
Thanks,
jimbo99999
We have been operating without any issues since my last posting. Do I just keep that trace window open and running until it happens again?
Thanks,
jimbo99999
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, gotcha. I understand now. Thanks for the insight. So we wait for the next time performance gets bad.