SQL 2005 performance optimization tips...

[Former Member]

Folks,

Can you please share your tips on optimizing SQL 2005 performance?

We are running ECC 6.0 IDES.

I have made sure that the data and log files are on two different drives.

Thank you in advance for your help.

Regards,

Peter

[Former Member]

Hi Peter,

There's actually some good reference information out on the net (a quick google should find a few). Here's a link to a doc from MicroSoft: [SAP on SQL Server Best Practices Whitepaper|http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SAP_SQL2005_Best%20Practices.doc ]

Hope that helps.

J. Haynes

Edited by: Joe Haynes on Oct 22, 2008 1:18 PM

[Former Member]

Hi,

And I can confirm that this doc from Microsoft is a must read.

I was surprised to get a better documentation from Microsoft than from SAP....

Regards,

Olivier