Performance Counters - SQL Server Express

• mnDBA

  SSCrazy

  Points: 2032

  More actions

  February 16, 2010 at 3:29 pm

  #138931

  Our Server Team just did the default OCS (Office Communication Server) install for a pilot we are running. By default, the install uses SQL 2K5 Express. Part of my task is to monitor the database side of things to determine if/when we need to migrate the database elsewhere.

  It would appear that the normal bout of perfmon counters for the Express instance did not install. I have not run into perfmon counters not installing since SQL Server 2000. I tried some loadctr commands and nothing seems to work.

  Anyone know if this is a limitation of Express or OCS?

  I find this very frustrating!

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 17, 2010 at 3:27 am

  #1119927

  I hope th following links are helpfull:

  http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx

  http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

  http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

  http://www.teratrax.com/articles/sql_server_2005_express.html

  Regards,

  Welsh

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/