Solved

SQL Benchmarking - Throughput and Response Time Analysis

Posted on 2012-04-11
1
218 Views
Last Modified: 2012-12-05
Hello,
I need to do some Benchmarking and first establish some baseline performance metrics.
What are the steps involved.

Requirements: Replication from Production system (OLTP) DB Server   TO  a BI / Reporting  DB Server, both running SQL Server 2008.

I want to Benchmark Throughput, Response Time, and establish baseline performance measures, then as the transaction increase and system grows over time I can do some trending and analysis.
I know that Benchmarking involves COMPARISION of performance between two systems or entities.  Could someone help me get started.

Secondly, is there a SQL SCRIPT or Program that I could use to do data collection and measurements OR do you have to by a Tool or Benchmark application?
0
Comment
Question by:lwilliams1809
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 37836364
Big topic, because there are more than a few possible approaches and depends on how much you want to do, how familiar you are with the various performance counters, how well versed you are with T-SQL (and tools), or how much budget you have.

Being a basically lazy person with some budgets, I would normally look for a third party product that specialises in such matters. They tend to be able to produce the comparison reports, graphs and charts etc... So, the laziness comes into the presentation layer of the captured information :)

So, first start by having a look at some of the activities available via SQL Server : http://msdn.microsoft.com/en-us/library/ms179428(v=sql.100).aspx

Then have a look at some of the third party tools : http://www.idera.com/SQL-Server/SQL-diagnostic-manager/ or http://www.red-gate.com/products/dba/sql-monitor/ to name but two of the several commercial products.

There is also a pretty good series about perfmon which gives a few more insights into which counters and why... http://sqlblog.com/blogs/kevin_kline/archive/2008/03/28/the-most-important-performance-monitor-counters-for-sql-server.aspx
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question