June 26, 2014 at 9:54 pm
We're in need of separating two of our existing databases onto their own SQL servers. I come from a programming background so my experience with SQL is not that great. All I know at the moment is that our current SQL server is running about average 40% CPU usage and it's 99% because of the DB we want to move off it. I know this because when we cut all the connections to that DB the CPU usage stabilized. 🙂 I know, know not the greatest method of testing.
Here is a screen shot of the Batch Requests/sec on this server:
http://screencast.com/t/p2FjsczINp
Would this be decent enough info to be able to suggest what our next server should be? We rent our servers so it would be a rental, would it be reasonable to run a budget of about $800/mo for this? too little? too much? Any help would be greatly appreciated.
June 26, 2014 at 10:06 pm
40% CPU utilization is not enough to get me to get a new SQL Server.
If there are performance issues, I would start looking at other things.
If things are slow, and you suspect CPU, have you changed the power plan on Windows to High performance?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 26, 2014 at 10:10 pm
I had no idea power options would have an impact on that, I always though it had to do with battery powered computers. I have now set it to high performance.
I would still love to separate these two databases as they really need to be separate. They are completely different businesses and they need their own servers. Would you have some suggestions on the box we should get?
June 27, 2014 at 2:11 am
There's really not enough information here. To evaluate hardware, I'd normally do a full week (or more) analysis on wait stats and perfmon counters (lots of them) at the least.
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
June 27, 2014 at 4:38 am
And chances are really good if you don't have a DBA around that there are statistics inside the databases that need to be updated, there may be query tuning opportunities, bad or missing indexes, a lot of stuff that could radically affect performance in a positive manner without throwing hardware at the problem.
"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
June 27, 2014 at 7:35 am
Since the move is more political and not performance based, sure go ahead and move the db no matter what the performance is.
That said, to make hardware choices more info is needed. A good starting point is what Gail said.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 8:15 am
ado-712642 (6/26/2014)
I had no idea power options would have an impact on that, I always though it had to do with battery powered computers. I have now set it to high performance.I would still love to separate these two databases as they really need to be separate. They are completely different businesses and they need their own servers. Would you have some suggestions on the box we should get?
Because you post on sql server 2008, I'm sure you already know, but to remind that there are many enhancements with upper versions of sql server (2012 and 2014) - http://technet.microsoft.com/en-us/library/bb510411(v=sql.110).aspx
Igor Micev,My blog: www.igormicev.com
June 27, 2014 at 9:44 am
I'd love to hire a DBA to go over this and figure out what we need to do. Even if it's making adjustments to our queries as I know we slacked off when it was initially put together. Would we be able to easily hire someone here or anyone know how we could hire a DBA for consulting?
June 27, 2014 at 9:49 am
ado-712642 (6/27/2014)
I'd love to hire a DBA to go over this and figure out what we need to do. Even if it's making adjustments to our queries as I know we slacked off when it was initially put together. Would we be able to easily hire someone here or anyone know how we could hire a DBA for consulting?
Plenty of consultants out there like myself and my group. You could reach out to us from here[/url].
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2014 at 10:06 am
Awesome. I'm in the right place. So how do we go about this? Is there a set pricing model on a week per week basis or hourly? How do we figure out how much our initial consultation will cost.
Thanks.
June 27, 2014 at 10:15 am
You can get my pricing by contacting us through the link I provided. Discussions on model, pricing, and scope can also be carried out there.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply