June 23, 2010 at 9:18 am
Hi All,
I am having a testing server(16 GB memory) 14 GB for SQL SERVER on which USER complaining about the slowness.
can anybody suggest me a path how to go and check the reason for this?
thanks
Puneet
June 23, 2010 at 9:21 am
June 23, 2010 at 7:56 pm
pujain (6/23/2010)
Hi All,I am having a testing server(16 GB memory) 14 GB for SQL SERVER on which USER complaining about the slowness.
can anybody suggest me a path how to go and check the reason for this?
thanks
Puneet
1.Check your server if any Antivirus program is installed which might be eating up memory.
2.Check your indexes for any fragmentation, stale statistics, etc
2 is mostly the culprit you have to closely look at !
HTH,
cheers !
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
June 24, 2010 at 3:14 am
I just found that all of my Replication Cleanup Jobs(Agent History Cleanup, Distribution cleanup etc) were not running.
Does it impact the performance of Server?
June 24, 2010 at 3:25 am
Not really , but your distribution database would be growing in size.
Follow the links i gave you before.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply