Post reply

Benchmarks for new server

  • March 28, 2009 at 7:13 am

    #219482

    What are the first things you do when you on someone SQL Server for the first time and it in production.

    What benchmarks do you do to ensure it running and determine what bottlenecks are.

    1. WaitStats

    2. Check memory configuration

    3. TempDB

    4. Disk Locations MDF and LDF split on difference disks perferably SAN.

    5. Can't do IO tests as on Production.

    Any others ?

  • March 28, 2009 at 12:23 pm

    #967918

    Double post, replies here.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply