<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Strategies
»
Load balancing
11 posts, Page 1 of 2
1
2
»»
Load balancing
Rate Topic
Display Mode
Topic Options
Author
Message
bmw110001
bmw110001
Posted Friday, September 25, 2009 8:32 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, July 24, 2012 3:30 AM
Points: 17,
Visits: 42
Dear All
Need to know can we perform load balancing among different databases located on the same server.
Post #794129
Grant Fritchey
Grant Fritchey
Posted Monday, September 28, 2009 7:12 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436,
Visits: 25,281
There's no real way to limit access of a given database to memory or cpu on the server. If you have a badly performing database, you'll need to isolate it from the others by moving it to a different server or a different instance of SQL Server.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #794488
bmw110001
bmw110001
Posted Tuesday, September 29, 2009 5:50 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, July 24, 2012 3:30 AM
Points: 17,
Visits: 42
hi Grant Fritchey
Have done everthing to solve the issue even moved db from 2005 to 2008 but still the issue persists
Post #795045
Andrew Gothard-467944
Andrew Gothard-467944
Posted Tuesday, September 29, 2009 8:31 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 29, 2010 5:23 AM
Points: 194,
Visits: 2,357
The point Grant is making is that if you have a 'problem' database - then in order to prevent it impacting on other databases on the server - the solution would be to move it somewhere else, like to another server. Upgrading only means you now have a badly performing upgraded database - it does onthing to solve the root problem.
Obviously a rewrite may be an option if it's poorly designed - or the app(s) swamp it with passthrough queries - but it's obviously not a quick solution - and incurs business risk
Post #795166
TheSQLGuru
TheSQLGuru
Posted Tuesday, September 29, 2009 8:41 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 9:14 PM
Points: 3,674,
Visits: 5,174
I can think of 3 solutions:
1) Hire a professional to help you tune the poorly performing database. It seems that you are not a SQL Server guru so I bet there are lots of things that could be improved. This is NOT a personal attack, just an observation based on years of experience.
2) Upgrade (at significant expense) to SQL Server 2008 Enterprise Edition and then take advantage of the Resource Governor. Note that you cannot 'govern' IO, which is a limitation of this subsystem.
3) Have 2 instances on the server and put the 'bad' database on one of them and then restrict that instances CPU and Memory. Expect exceedingly poor performance of that database however, but it could free up sufficient resources to allow the other database to perform acceptably.
Note that you should try to put the 'bad' database on separate IO subsytem if at all possible in any event.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #795177
Grant Fritchey
Grant Fritchey
Posted Tuesday, September 29, 2009 9:00 AM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436,
Visits: 25,281
bmw110001 (9/29/2009)
hi Grant Fritchey
Have done everthing to solve the issue even moved db from 2005 to 2008 but still the issue persists
Then I guess the core question is, what's the issue? What problems are you having?
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #795207
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, September 29, 2009 9:12 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Note that what you appear to want is not load balancing, but rather restricting the use of resources between databases.
Using VMs will give you some control, but at the expense of other issues. As TheSQLGuru mentioned, you probably want to engage a consultant if you have no idea how to work with the load. It's not a knock, but rather it's a chance for your to learn a lot in a short period of time from someone else.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #795218
bmw110001
bmw110001
Posted Tuesday, September 29, 2009 12:29 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, July 24, 2012 3:30 AM
Points: 17,
Visits: 42
it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea
Post #795373
TheSQLGuru
TheSQLGuru
Posted Tuesday, September 29, 2009 12:47 PM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 9:14 PM
Points: 3,674,
Visits: 5,174
bmw110001 (9/29/2009)
it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea
I restate my first idea:
1) Hire a professional to help you tune the poorly performing database. It seems that you are not a SQL Server guru so I bet there are lots of things that could be improved. This is NOT a personal attack, just an observation based on years of experience.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #795387
Grant Fritchey
Grant Fritchey
Posted Tuesday, September 29, 2009 1:26 PM
SSChampion
Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436,
Visits: 25,281
bmw110001 (9/29/2009)
it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea
Eliminate the loop?
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #795408
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
