SQL Server Performance

Sql Server 2005 Performance issue

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by sonnysingh, Apr 12, 2007.

  1. sonnysingh Member

    Hi Folks

    I am using SQL Server 2005 Standard Edition. Somehow it is getting slow with most of the activities such as saving jobs after create or modify them, SSIS package saving activity, expanding some of the folder e.g. Database, Notification services, Alerts etc..

    System Detail are:
    1. Windows Server 2000
    2. 5.0.2195 Service Pack 4 build 2195
    3. OptiPlex GX520 x86-based PC
    4. Dual processor x85 family 15 model 4 stepping Intel
    5. 1,038,408 KB memory

    It is dedicated SQL Server 2005 box..

    What could be wrong with it?? even I checked processes runing on the server and there are no process that could eating up the resources of server.

    Please help.. and Thanks in advance
    sonny
  2. Luis Martin Moderator

    Any anti virus running?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. sonnysingh Member

    yes..
    1. couple of hotfixes
    2. microsoft office 2003
    3. Symantec Antivirus
    4. Live update of Symantec

    But Luis even I right click on the specific database to see properties or any other folder. It's taking more time than usual time.

    Thanks
  4. thomas New Member

    Are you using Management Studio on a client PC connecting to the server? Or are you running it on the desktop of the server?
  5. Luis Martin Moderator

    AV could be the reason.
    Try without AV.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  6. satya Moderator

  7. MohammedU New Member

    Is SQL SERVER 2005 64 bit? If yes check the following article...

    You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems
    http://support.microsoft.com/kb/906892


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  8. ghemant Moderator

    quote:Originally posted by sonnysingh

    yes..
    1. couple of hotfixes
    2. microsoft office 2003
    3. Symantec Antivirus
    4. Live update of Symantec

    But Luis even I right click on the specific database to see properties or any other folder. It's taking more time than usual time.

    Thanks
    I guess it cause because of law virtual memory, do you face sluggishness on your server? IS their any other application eating up more memory or check if your disk has enough room for pagefile.

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  9. satya Moderator

    Don't think so as the hardware is xOptiPlex GX520 x86-based PC[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by MohammedU</i><br /><br />Is SQL SERVER 2005 64 bit? If yes check the following article...<br /><br />You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems<br /<a target="_blank" href=http://support.microsoft.com/kb/906892>http://support.microsoft.com/kb/906892</a><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>

Share This Page