Post reply

Running SQL Server 2008 with Local Admin or Domain user

  • November 20, 2010 at 6:20 am

    #229441

    Hi,

    Last week we upgraded our system

    Sql server 2005 to Sql server 2008

    Windows 2003 to Windows 2008

    32 cpu 64 gb ram to 64 cpu 256 gb ram

    One server strcuture to Microsoft cluster

    But our system is running slowly. Sometimes (random times) our queries are so much slow such as 10-20 times then older time.

    When i connect to sql server as domain user it takes (the login time) about 8-9 seconds.

    As sql server user (SA) the login times takes less then 1 second.

    Our sql server service is running now as domain user. Is it possible that the reason for slowing is running service as domain user?

  • November 20, 2010 at 6:38 am

    #1253393

    duplicate post.

    Please reply here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • November 20, 2010 at 6:11 pm

    #1253450

    hey man, i suggest you troubleshoot performance problems for your SQL Server 2008. that might help you.

    walterjone96 🙂

  • November 20, 2010 at 9:12 pm

    #1253456

    Hi there,

    My recommendations are:

    1-Check the windows policy (create a Service account with the minimum prev.)

    2-Check the Windows NIC card, they need to be in Order. Uninstall IPV6.

    3-Check id the SQL VIP/APN is not using DHCP.

    3-Move your DB'S to multiple HardDrive.

  • November 21, 2010 at 5:50 am

    #1253487

    this is already in discussion at the link posted by LutzM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 5 (of 5 total)

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