Solved

hybrid environment

Posted on 2013-06-07
4
301 Views
Last Modified: 2013-06-09
I currently have Windows 2003 Server on our domain controller and SQL server 2008.  All our clients are Windows 7.  We are upgrading our SQL box.  The question I have is if we upgrade the SQL box to Windows 2008 or 2012, will that become an issue if we leave the domain controller as a 2003 Server.   Does it allow a hybrid enironment?  

Is there any benefit also to upgrading to SQL 2012?

To me, it seems like these upgrades are unnecessary and maybe we should just stick to our old 2003 Server with SQL 2008.

Your thoughts on the matter are appreciated!
0
Comment
Question by:al4629740
[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
  • 2
4 Comments
 
LVL 8

Assisted Solution

by:didnthaveaname
didnthaveaname earned 250 total points
ID: 39231027
So here's my outlook. While there certainly are performance enhancements in the major sql releases, if you don't have performance issues with your current version and you don't need the new features, why spend the money? New  toys are great, I love to play with them, but there has to be a business justification. Features-wise, here are some of the top features: http://mcpmag.com/articles/2012/03/14/top-12-features-of-sql-server-2012.aspx?m=1 (and don't get me wrong, availability groups alone were the reason my company decided to upgrade, but not everyone needs that). In terms of the OS... You are *absolutely* going to see performance improvements from upgrading there.  You're talking about an OS that is a decade old and is going to be end of lifed in 1-2years.  Especially if you're contemplating a virtualized sql server. And you're fine with joining a server 2012 machine to a 2003 forest/domain level.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39231266
If you don't need high availability and some new features mentioned above, there is no point for you to upgrade.  Just make sure you got your latest service packs installed to have support.
0
 

Author Comment

by:al4629740
ID: 39231557
I do need better performance because many queries are not pulling up fast
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 250 total points
ID: 39231660
Better Performance is not primarily obtained by version upgrade but by better hosting infrastructure (IO and CPU resources) and applicative design (indexing).  Don't waste time on upgrade and focus your efforts onto these aspects.

Hope this helps.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

733 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