InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:16:42 GMT20http://www.sqlservercentral.com/Forums/Topic588394-146-1.aspxcreating performance baseline bcoz we need to do migration and i m doing testing with this scenario .so are this counters suffecient and wat about cache hit ratio .. is the cache hit ratio ok for this.Mon, 20 Oct 2008 22:14:52 GMTsamsqlhttp://www.sqlservercentral.com/Forums/Topic588394-146-1.aspxAre you experiencing a specific problem or just creating a performance baseline?Mon, 20 Oct 2008 04:01:53 GMTClive Stronghttp://www.sqlservercentral.com/Forums/Topic588394-146-1.aspxwaiting for the reply....................Mon, 20 Oct 2008 03:36:24 GMTsamsqlhttp://www.sqlservercentral.com/Forums/Topic588394-146-1.aspxhi all,I m checking couters for performance tuning ...server config 28 GB ram windows 2003 sql x64 enterprise edition 3GHz processor i want more sugesstions for these counters .. is thr any thing which can be more added.. are this counters suffcientdatabase size 5 GB.... Counters Processor Time 60% Buffer Manager Buffer cache hit ratio 98.54Lazy wirtes/sec 0checkpoint pages/sec 10.242 Sql Statistics Batch requests/sec 0 General statistics user connection 4 Memory Manager Sql cache Memory (KB) 344Target server Memory (KB) 3551424Total server Memory (KB) 1721600 SQL ERRORS SQL errors/sec 0 Memory Memory pages/sec 0 Logical Disk Avg.diskqueueLenght 0.496Avg.diskreadqueueLenght 0.036 Physical Disk %Disk Time 0.8Avg.diskqueueLenght 0.021CurrentdiskqueueLenght 0 Plan Cache Cache Hit Ratio 70.551 Number of deadlocks 0Mon, 20 Oct 2008 01:26:03 GMTsamsql