Home > IT Answers > SQL Server > System hangout
Udaykirak
15 pts.
 System hangout
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

Software/Hardware used:
ASKED: June 10, 2009  1:11 PM
UPDATED: June 10, 2009  8:18 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  June 10, 2009  8:18 pm  by  Karl Gechlik   9,815 pts.
All Answer Wiki Contributors:  Karl Gechlik   9,815 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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 ?

carlosdl
 63,535 pts.