SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Consolidation Matters

Throughout my career I've been looking to consolidate SQL Servers when I find them. The typical employer I've had usually grows their IT infrastructure over time and many projects look like this:

  • Build or buy a software package
  • Buy a new server
  • Install SQL Server and one database for the application

Over time this means I find lots of individual servers running at much less than full capacity. That's something that DBAs like, because it means that we can handle the inevitable spikes in resource usage that our workloads will encounter. However that's not what the rest of the business, especially the financial management, wants. Underused resources mean money that isn't spent well.

As a result, I've often looked to consolidate instances where possible. Often I let an instance run by its own hardware for a period of months, perhaps even a year, during which I can get a good idea of what level of resources the database and application require. Once I have that, I try to match up the needs with an existing SQL Server that might be underutilized by at least that amount of resources. Typically I'm looking at RAM and CPU since disk resources can often be transferred to a new piece of hardware. It's not quite as simple as it sounds as I also need to look at workload patterns and potentially match up instances whose workload peaks occur at different times.

I've successfully consolidated many instances this way, often reducing the amount of physical hardware in data centers substantially. As hardware cycles turn over and newer machines are purchased, I can usually repeat the process again and again. The advent of virtualization has made this even easier as bad guesses can usually be reversed or corrected by moving the database to a different instance.

I suspect that virtualization will become more important in the future, especially as licensing changes in SQL Server make it much more expensive to add the ad hoc instance on its own hardware. I'd encourage you to plan on consolidating new databases from the beginning to ensure that your organization gets the most performance out of the hardware that it has purchased.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 2.5MB) podcast or subscribe to the feed at iTunes and LibSyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

Free eBook
Fundamentals of SQL Server 2012 Replication

By Sebastian Meine
fundamentals of SQL Server Replication Some say resistance is futile...
...but Sebastian Meine knows better.

With this eBook, adapted from the Stairway to Replication, learn the different kinds of replication and how to use each one. Replication isn't always the answer, this eBook also explains when log shipping or AlwaysOn are better options.

Download Fundamentals of SQL Server 2012 Replication
free from Red Gate

Featured Contents


Automating Database Restores

Sujeet Singh from SQLServerCentral.com

This article describes a way to automatically restore multiple database backups from a directory. More »


Monitoring SQL Server: An Interview with David Bick

Additional Articles from SimpleTalk

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore. More »


SQL Saturday #308 - Houston, TX

Press Release from SQL Saturday

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014. Register while space is available. More »


From the SQLServerCentral Blogs - The system_health Extended Event Session

Patrick Keisler from SQLServerCentral Blogs

When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created... More »

Question of the Day

Today's Question (by Steve Jones):

True or False: You can run SQL Server in your existing data center and store data files for a database in the Azure cloud storage?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SQL Server 2014.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


Tribal SQL

SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What's the hot key to get the results in Management Studio (SSMS) to come out as text instead of a grid?

Answer: CTRL+T


The answer is CTRL+T. If you click this hot key, you will get results from your queries as text, which is handy for pasting short results into other documents.

Ref: SSMS Keyboard Shortcuts - http://technet.microsoft.com/en-us/library/ms174205.aspx

» Discuss this question and answer on the forums

Featured Script

backup, differental and transactions

Andrés Michaca from SQLServerCentral.com

Script for backup of all database taking into account the recovery mode

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2014 : Development - SQL Server 2014

Microsoft SQL triggers on columns - Dear All I have one table namely consumer with approx 50 columns. I have created one same table with audit prefix including...

SQL Server 2012 : SQL 2012 - General

Calculated columns conditional on calculated columns multiple tables - I have 4 tables involved here. The priority table is TABLE1: NAMEID TRANDATE TRANAMT RMPROPID TOTBAL 000001235 04/14/2014 335 A0A00 605 000001234 04/14/2014...

Deployment Failure Heirarchy - Working on analysis services tutorial where i am modifying measures and my heirarchy and this is my error message. Warning 1 Dimension...

Please create a master key in database of open master key in the session before performing this operation. Error 15581 - I really could use some guidance on this issue. Background.... Windows somehow got corrupted and wouldn't come back up. We did a...

Powershell and Alwayson Question - I'm trying to join an availability group to a cluster node using the command below in powershell. I receive the...

Get Table Structure of Stored Procedure Output Table - To get the results of a stored proc into a table you always had to know the structure of the...

SQL Server 2012 : SQL Server 2012 - T-SQL

Query Performance - Hello, I have written this sample query to search a full-text indexed table and return the results. If the word...

Convert Bigint time to datetime - Hi, How to convert bigint time to datetime (CST) Declare @MyBigIntTime BIGINT =1397750400000 Thanks, PSB

Output of a table required in a specific format. - Hi all, I need to display the output of a table in a specific format, I have attached the sample screenshot...

SQL Server 2008 : SQL Server 2008 - General

DB Mirror,synchronized/restoring...) - Hi gurus After rebooting the sql server 2008 R2 , I opened SSMS and found out that right beside my database...

Instance failover failing in Cluster - I am getting the following error when I am trying to failover an instance to another node: The operation failed because...

start sql - how to start sql in single user mode through command prompt ? suppose slq biiniaries are installed in E drive ?

Incorrect Syntax error, but nothing is wrong? - Here are my final 2 lines of code and the resulting error: SELECT * FROM #tblTrackPoints DROP TABLE #tblTrackPoints Msg 102, Level 15, State...

Need Query for Problem - [code="sql"] create table #sample ( product varchar(100), Price varchar(100) ) insert into #sample values ('Pen',10) insert into #sample values ('DVD',29) insert into #sample values ('Pendrive',45) insert into...

SQL Server 2008 : T-SQL (SS2K8)

Need help in converting rows into column... include attached image file in detail - Team, It is possible to covert rows into column by using tsql script, please see attached file for more details, please...

Spatial, lines crossing - Hi ... this is what I want to do to thousands of lines in one table .... find all lines with CROSSING...

SQL Server 2008 : SQL Server Newbies

Sorting - Hi, this is going to be my first time posting in this forum and I'm currently studying SQL at the...

SQL Server 2008 : SQL Server 2008 High Availability

Mirror disconnected - I have sql server 2008 on windows 2008 Mirror configured with Witness(Certificate authentication) today I found that Mirror disconnected state.I got the...

SQL Server 2008 : SQL Server 2008 Administration

sa can't access but newly created user performed like sa - dear experts, i just created a user on SQL server 2008. named 'gakk/amin' and after that i can't access by...

trace -2543 - We have trace 2543 set globally on our active passive cluster. I haven't found any information on this trace flag....

SQL Server 2008 on windows 8 - Hi Experts, I want to install SQL Server 2008 Enterprise edition 32 bit on Windows 8 64 bit, I am not...

Reporting Services : Reporting Services 2008 Development

Subreport left padding not working - I have developed a report which contains a matrix followed by a list object. Within the list object I have a...

ssrs 2008 visibility of column - In an SSRS 2008 r2 report, I just added some 3 more column groups to the existing detail line report....

ssrs 2008 r2 dataset call stored procedure - I am modifying an existing SSRS 2008 r2 report. In a dataset that already exists within the ssrs 2008 r2...

How to make the report to display week wise data - Hi, I want my report to fetch data from Financial year starting to till date. i.e Apr 2013 to till date. till date...

Programming : General

No Value Given For One or More Required Parameter oledb to Excel - In order to avoid the 255 character limitation in Excel and SSIS I have written a VB.Net SSIS script to...

SQLServerCentral.com : Anything that is NOT about SQL!

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com