1

sqlserver 2005 sp3 poor performance and scheduled job failing

view story
linux-howto

http://serverfault.com – I had to execute the microsoft SQL 2005 best analyzer and i am getting some errors on the SQL database server as following. i really appreciate your recommendation,suggestion and comments. The Outdated system driver [C:\WINDOWS\system32\ntoskrnl.exe] of System that can cause paging detected. Disk sector [0] alignment of server is not configured optimally. work with their hardware vendor on optimal settings.In order to fix this potential issue, you will have to recreate and reformat the suboptimally aligned partition. "Hard disk sectors are optimally configured to have a star (HowTos)