sqlserver or ntperf

Discussion created by jonhcw on Nov 24, 2012
Latest reply on Nov 26, 2012 by 1_keithk



I'm doing a bit of redefining for SQL monitoring parameters. I was wondering what meaningful differences there are between using ntperf and sqlserver to monitor MS SQL server? Most, maybe all, stuff that are by default configured as templates in sqlserver can are also published as Performance counters by the SQL server. There are naturally some more complex metrics you could check with SQL queries with sqlserver, but in regular monitoring those are not often needed in my opinion. Licensing/billing is of course different, but I'm thinking more technology oriented here.


There's a lot of stuff to watch in SQL, would also love to hear what everyone thought are the musts and good to haves, regarding monitoring. I'm mostly interested in MSSQL 2005 and newer.