SQL Server Performance

Search Results

Search Again
  1. mishrsk

    What will be the write sequence of VLF?

    Thread by: mishrsk, Jul 13, 2010, 2 replies, in forum: SQL Server 2008 General DBA Questions
    Hello, Suppose I have 4 VLFs sequentially numbered VLF1, VLF2, VLF3 and VLF4 for one of my databases. Say VLF2 and VLF4 are active and VLF1 and VLF3...
  2. mishrsk

    cache use counts/sec - Drastic fall

    Thread by: mishrsk, Aug 7, 2009, 5 replies, in forum: General DBA Questions
    Windows 2003 Ent, SQL 2000 Ent with SP4. The processor utilization fall from 25% to 8%, Batch requests per sec fell from 8K to 400 and cache use...
  3. mishrsk

    Database Health and capacity projection

    Thread by: mishrsk, Jun 3, 2009, 3 replies, in forum: General DBA Questions
    Hi, Can somebody give direction on the following please. I wish to quantify workload and throughput of my SQL Server box containing one user database...
  4. mishrsk

    UPDATE STATISTICS - Variable run time

    Thread by: mishrsk, Dec 22, 2008, 11 replies, in forum: General DBA Questions
    Hi, I am running UPDATE STATISTICS with SAMPLE 30 PERCENT for one of my databases. When I am running it in busy times, it's taking almost 3 times...
  5. mishrsk

    Update Stats with Full Scan

    Thread by: mishrsk, Oct 2, 2008, 2 replies, in forum: Performance Tuning for DBAs
    Hi, I am on SQL 2000 SP4 with latest SQL patches. I am running the UPDATE STATISTICS WITH FULL SCAN on all tables twice a week. The time taken on...
Showing results 1 to 5 of 5
Search Again