Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

A Cheap Fix?

By Steve Jones,

I saw a note recently where someone had put up a new server in their environment. They build some ETL processes and replication in a short time to move data from the primary server to this new reporting instance. This was done to accommodate a few power users that wanted to write their own ad hoc queries, which had previously been causing performance issues on the main server.

Is this a good fix? Does it make sense to spent the $$ and time for another instance for a few users?

I saw a comment on the post where someone had noted that some performance tuning might have been a much better investment. That or limiting the access from the power users to prevent them from causing issues with large queries that might not be efficiently run.

Like most everything, I think It Depends. I've used this in cases where the ad hoc queries help the business. Either someone is running what-if type scenarios that can be used to feedback information to management, or they have the political power to make someone think they are. In either case, spending  money on a server and a little time makes sense for me.

However not every power user, or ad hoc query individual should have an instance. Keeping more than one or two instances in close sync can be an issue. Users that aren't familiar with how to query data, or even use a tool like Tableau, can be a huge drain on resources. There is also the management of additional instances. If you double your number of production instances, you might end up spending more time patching, monitoring backups, etc., than you want to.

I think this can be a cheap fix in limited use. It's a tool that I'd recommend DBAs keep in mind for heavy users, but not one that you should reach for quickly. Make sure it's a good fit, and it really implements a fix. After all, some performance tuning on your regular server might do the job, and it benefits all users.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's 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.

Total article views: 141 | Views in the last 30 days: 1
 
Related Articles
BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

BLOG

Podcasting

I'm working on getting a small studio set up for some podcasting of the editorials. That means I put...

ARTICLE

Podcast Announcements

Podcast Feeds

FORUM

SQL Server Instances

Muiltiple SQL Server Instances

BLOG

New Hebrew SQL Server Podcast

Five months ago, I wrote a post about my love for Podcasts. At some point, I started to think about...

Tags
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones