System hangout

15 pts.
Tags:
HCL
SQL Server performance
SQL Server performance tuning
I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem

Answer Wiki

Thanks. We'll let you know when a new response is added.

You need to check the task manager when the issue is happening to find the bottleneck.

You can also use the performance counters to do this automatically. Once you have the data you will see if it is a hard drive issue, processor or memory. Is your Database on the same drive as the operating system? What is the speed of the disk?

Make sure your data and os are separate. Add more memory if possible and see if that corrects your issue.

A great article for learning about performance counters and this stuff is here:

http://www.windowsnetworking.com/articles_tutorials/Key-Performance-Monitor-Counters.html

Feel free to email me with your results and I will help you break it down. karl at asktheadmin dot com.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Is some specific program running at the time when the performance goes down ? Does it happen with other clients also ? Have you checked if the antivirus software has a scheduled scan for that time ?
    69,065 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following