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
Also look at database file initialization at:
ReplyDeletehttp://msdn.microsoft.com/en-us/library/ms175935(SQL.90).aspx