Post reply

What is benchmark of sql server?

  • April 6, 2011 at 4:18 am

    #249095

    What is benchmark of sql server?

    Thanks

  • April 6, 2011 at 4:23 am

    #1307910

    Don't understand the question.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 6, 2011 at 5:50 am

    #1307943

    Each and every SQL Server installation is different. Different servers of different CPU speeds & numbers, with varying amounts of memory. Different databases with different applications and varying number of users running different kinds of queries. In short, there is not a single SQL Server Benchmark. Instead, you need to establish how your installation of SQL Server behaves, both under load and standing idle, so you can begin to understand when you have performance problems.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 18, 2011 at 1:27 am

    #1312621

    Thanks...from Where I can start..Currently with close we just start installtion wiith very fw checks...:-D

    Thanks

  • April 18, 2011 at 4:50 am

    #1312673

    You could have specified the environment detail, what type of IO you are expecting etc this clould have helped us in answering your query.

    "More Green More Oxygen !! Plant a tree today"

  • April 18, 2011 at 5:35 am

    #1312689

    forsqlserver (4/18/2011)

    Thanks...from Where I can start..Currently with close we just start installtion wiith very fw checks...:-D

    You have to set up the monitors. Start now. For a general set of monitors I'd recommend taking a look at my book, SQL Server 2008 Query Performance Tuning Distilled (link is below in my signature). It shows how to gather a basic baseline.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 6 posts - 1 through 5 (of 5 total)

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