Post reply

Running SQL Server 2008 with Local Admin or Domain user?

  • November 20, 2010 at 6:30 am

    #229442

    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:39 am

    #1253394

    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]

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

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