perfmon

Archive of posts tagged perfmon

Performance Counters

Posted by Derek Dieter on 17 June 2009, 10:12 pm

The following list of performance counters have been modified to include the most pertinent in identifying the bottleneck of your system. This list is for reference purposes. If needing to troubleshoot slowness read troubleshooting sql server slowness. Memory Object: – Memory Counter: – Available Mbytes Preferred Value: – > 2000MB Description: With 64 bit OS’s [...]

Filed under SQL Optimization, Troubleshooting. Tagged perfmon

2 Comments

Random MVP RSS Feeds
- [SQLTeam] How to import in BIDS more than one SSIS package in one shot!: Have you ever wanted to add more than o... http://t.co/ZfC9u8I1 08:38:24 PM February 02, 2012 from twitterfeed
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 01:33:19 AM January 31, 2012 from SQL Server Planet
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 07:58:09 PM January 29, 2012 from SQL Server Planet
- DROP INDEX SYNTAX - Here is the syntax needed in o... http://t.co/ElqNyG3e #fb 07:05:16 PM January 29, 2012 from SQL Server Planet
- SET TRANSACTION ISOLATION LEVEL - This statement is used to set... http://t.co/0zGtNE1X #fb 06:10:38 PM January 29, 2012 from SQL Server Planet
- [Aaron Bertrand] Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR: I see a lot of people suggest while ... http://t.co/oDLn0pVs 10:12:20 PM January 26, 2012 from twitterfeed
- [Simon Sabin] Ten reasons to attend SQLBits X: If you are contemplating attending then I hope the following will... http://t.co/Zg6uqojD 12:54:21 PM January 26, 2012 from twitterfeed
- [Simon Sabin] SQLBits x an awesome line up –1100 people have already registered: I was really happy to have put ... http://t.co/zQu3m5ix 07:48:47 PM January 25, 2012 from twitterfeed
- [Aaron Bertrand] SQL Server 2012 : The "Launch Date" is not what you think it is: I see a lot of people getting ... http://t.co/i87shAFB 02:18:00 AM January 24, 2012 from twitterfeed
- [Aaron Bertrand] Bad Habits to Kick : Using AS instead of = for column aliases: This one is quite subjective, an... http://t.co/5uzyQWCv 05:49:21 PM January 23, 2012 from twitterfeed