SQL Server 2008 - Log Settings

Jul 20, 2010 at 8:27 AM

Hello, I have been successfully using PAL 1.3 agaisnt some SQL 2000 instances and have decided to look at PAL 2.0 and use it against SQL 2008.

In the PAL 1.3 download there was a useful file called SQLServer2000.htm, which had all the reuqired settings to put into Perfmon.

Does anyone have the equivalent file for SQL 2008?

Thanks, John

Jul 22, 2010 at 7:35 AM

I tried using the SQServerL2000.htm to collect data in Perfmon, but neither PAL 1.3 or PAL 2.0 would produce any output (I think they gace up part way through processin g the log file).


Jul 22, 2010 at 8:15 AM

Just wondering - PAL 1.3 had a templates folder, but when I installed PAL 2.0 there wasn't one - am I OK to use the template from PAL 1.3? i.e. does it cater for SQL 2008?

Jul 22, 2010 at 9:14 AM
Edited Jul 22, 2010 at 9:15 AM

I have used the templates from thePAL 1.3 install and got a report!

Perhaps these should be included in the PAL 2.0 MSI, so others don't get confused like me?