I have a client who sells medical software and some of their clients are complaining about performance on SQL Server x64. A little research showed that the permissions for the account running the server were incorrect.
Looking at Microsoft's support site there are two links you should check out.
The first:
http://support.microsoft.com/kb/918483
Describes the problem in detail and permission and setting changes to help.
The second is a link the to hotfix that is available.
http://support.microsoft.com/kb/970070
Don't forget about enabling trace flag 845.
Dave
Showing posts with label memory settings. Show all posts
Showing posts with label memory settings. Show all posts
Monday, November 9, 2009
Subscribe to:
Posts (Atom)