SQL Server Performance

Search Results

Search Again
  1. Akthar Hussain

    counter: Page life expectancy - my data

    Post by: Akthar Hussain, Nov 9, 2011 in forum: Performance Tuning for DBAs
    no, at the moment there is no plan to as we plan to migrate to SQL 2008 on a win 2008 server. we want to have an understanding of what is going on...
  2. Akthar Hussain

    counter: Page life expectancy - my data

    Thread by: Akthar Hussain, Nov 9, 2011, 3 replies, in forum: Performance Tuning for DBAs
    Hi, I am monitoring a sql Server database cluster. I have found the average Page life expectancy to be 10.4 minutes and the maximum value was 267.4...
  3. Akthar Hussain

    batch request per sec - sql server 2000

    Post by: Akthar Hussain, Oct 17, 2011 in forum: SQL Server 2005 General DBA Questions
    Hi Preethi, Satya, Thanks for your advise. Yes, this is related SQL server 2000 version . Oh by the way, Satya, I attended your Liverpool, SQLBit...
  4. Akthar Hussain

    Page Splits/sec <20 per 100 Batch Requests/Sec

    Thread by: Akthar Hussain, Oct 14, 2011, 2 replies, in forum: Performance Tuning for DBAs
    Hi could some one check if my understanding is correct? e.g if page split per sec is 140 and batch request per sec is 1000 then [140/(1000/100) =...
  5. Akthar Hussain

    batch request per sec - sql server 2000

    Post by: Akthar Hussain, Oct 10, 2011 in forum: SQL Server 2005 General DBA Questions
    sorry i think the value there that i am looking at in sysperfinfo may be cumulative from the time the sql server was started... if anyone disagrees...
  6. Akthar Hussain

    batch request per sec - sql server 2000

    Thread by: Akthar Hussain, Oct 10, 2011, 6 replies, in forum: SQL Server 2005 General DBA Questions
    Hi I read Brad's article: http://www.sql-server-performance.com/2005/sql-server-performance-monitor-coutners/ The batch request per sec on our server...
Showing results 1 to 6 of 6
Search Again