Sql Server 2005 Performance Slow

Question

Sql Server 2005 Performance Slow

sgraj

Grasshopper

Points: 16
More actions
November 7, 2009 at 4:37 am

#227800

Hi,
The sql server 2005 performance is very slow between 2 to 4 PM even there are very limited users. The client screens loading time taking long. It is working regularly at other times and after restarting the server . The server is IBM server X-226 series (Xeon Procesor 3 GHZ(dual),2 GM RAM,140 GB Hard disk). It will be helpful if you suggest any solution to the above problem.
Thanking You,
S. Govindaraj.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

sgraj (11/7/2009)
Hi,
The sql server 2005 performance is very slow between 2 to 4 PM even there are very limited users. The client screens loading time taking long. The server is IBM server X-226 series (Xeon Procesor 3 GHZ(dual),2 GM RAM,140 GB Hard disk). It will be helpful if you suggest any solution to the above problem.
Thanking You,
S. Govindaraj.

Check to see what sql jobs are running, check for other processes non sql running. you could if possible run a limited profiler trace at this time, or you could monitor it yourself manualyl between these times.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

sgraj Grasshopper Points: 16 More actions · Answer 2

Hi,

Thanks for the reply. No sql jobs are running at that time. I try the sql tracer.

S. Govindaraj

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

By the way, check to see any Database Backups are running?

If not SQL Server Agent, may be any other scheduler (Windows Task Scheduler) is calling a Job which does anything. One of my Servers had the similar issue and we later found that Symantec Anti-Virus is running during that particular time.

So check with the System Engineer / Admin and discuss these possibilities.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty