anyone use a 3rd party product to load balance SQL Server?

I'm working on a project needing a high-end large mission critical database
solution. The data is in 1 database. So SQL 2000 doesn't support load
balancing, and neither will 2005. That sucks. Oracle supposedly does load
balancing and I can't understand why even SQL Server 2005 won't do it. So
either I go with an 8+ CPU SQL Server or consider a 3rd party load balancer
that will somehow (?) make it work so that multiple SQL brains can balance
the load of 1 single database that is presumably shared on 1 set of disks.
I'm finding very little information on load balancing SQL Server when
searching the net. Is there a product like Legato, for example, (I haven't
tried it) that will somehow give me load balancing with SQL Server?HK wrote:
> I'm working on a project needing a high-end large mission critical
> database solution. The data is in 1 database. So SQL 2000 doesn't
> support load balancing, and neither will 2005. That sucks. Oracle
> supposedly does load balancing and I can't understand why even SQL
> Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> consider a 3rd party load balancer that will somehow (?) make it work
> so that multiple SQL brains can balance the load of 1 single database
> that is presumably shared on 1 set of disks.
> I'm finding very little information on load balancing SQL Server when
> searching the net. Is there a product like Legato, for example, (I
> haven't tried it) that will somehow give me load balancing with SQL
> Server?
You may want to take a look at Federated Database Servers on SQL Server
2000/2005 if that architecture will work for you.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uzLN8u5wFHA.3180@.TK2MSFTNGP14.phx.gbl...
> HK wrote:
> > I'm working on a project needing a high-end large mission critical
> > database solution. The data is in 1 database. So SQL 2000 doesn't
> > support load balancing, and neither will 2005. That sucks. Oracle
> > supposedly does load balancing and I can't understand why even SQL
> > Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> > consider a 3rd party load balancer that will somehow (?) make it work
> > so that multiple SQL brains can balance the load of 1 single database
> > that is presumably shared on 1 set of disks.
> >
> > I'm finding very little information on load balancing SQL Server when
> > searching the net. Is there a product like Legato, for example, (I
> > haven't tried it) that will somehow give me load balancing with SQL
> > Server?
> You may want to take a look at Federated Database Servers on SQL Server
> 2000/2005 if that architecture will work for you.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
Creating the partitioned views sounds very challenging for an already-in-use
DB that needs to be cut over in the middle of the night. Plus ongoing
maintenance. Maybe I'm missing the boat, but that's why I'd want to stay
away from federated databases.

Anybody played with SmoBrowser example within smo?

I was looking at the smo examples that come with sql server 2005/VS 2005

and I have found quite interesting how it was neat and easy to load everthing in a treeview using reflection.

I come to my question:

I would like to load a treeview control that I could reuse in the same way but depending on the needs i would like only to load certain stuff not all of them.

EG (Not all objects but just DatabaseCollection,TableCollection)

Is there a way I can ovverride IsExpandablePropertyType so that i can decide what i can load?

any suggestions

I have adopted the SMOBrowser source code to upgrade one our products, SQL2000Print that prints SQL Server 2000 object information using DMO. The new product will do the same for SQL Server 2005 using SMO. I load the treeview only with the database objects that I want to load, and in a structure that is similar to Microsoft SQL Server Management Studio.

I have uploaded a development version to our website (here is the download link http://www.starprint2000.com/downloads/beta/sqlserverprint2005.msi) that prints Tables, Views and Stored Procedures from SQL Server 2005. You are welcome to download it and try it.

If you want to load your treeview the same/simliar way please let me know, I will be happy to share the code for loading the Treeview.

Regards,

Joginder Nahil
www.starprint2000.com

|||

Hi there

thanks for your reply.I would be extremely grateful if you could share the code for the treeview .

you can email it at vbjunkie@.hotmail.co.uk and let me know.

Thanks a lot

|||

I have modified the SMOBrowser example, that you download using the following link, to demonstrate how you can load the treeview with the datbase objects of your choice.

http://www.starprint2000.com/downloads/SmoBrowser.zip

The zip file contains readme.doc that documents the changes and provides information showing how I loaded the Treeview using XML to my own tree structure.

Regards,

Joginder Nahil
www.starprint2000.com

|||

Thanks a lot for your link.

One last question.In one scenario I just wanted to load one database,not all of them.

Can i do that?

thanks again

|||

I have modified the SMOBrowser example, that you download using the following link, to demonstrate how you can load the treeview with the database objects of your choice AND only the database in the list:.

http://www.starprint2000.com/downloads/SmoBrowserDBOnly.zip

I have modified the code for procedure PopulateCollectionItems to check if the item to be loaded is a Database object and its name is in the list of names to be loaded.

Private Sub PopulateCollectionItems(ByVal node As TreeNode)
Dim oldCursor As Cursor = Me.Cursor
Me.Cursor = Cursors.WaitCursor
Try
For Each item As Object In CType(node.Tag, ICollection)
Select Case TypeName(item)
Case "Database"
If DatabasesToLoadList.Contains(CType(item, Database).Name) Then
node.Nodes.Add(CreateNode(item))
End If
Case Else
node.Nodes.Add(CreateNode(item))
End Select
Next
Finally
Me.Cursor = oldCursor
End Try
End Sub

Regards,

Joginder Nahil
www.starprint2000.com

|||

I have modified the SMOBrowser example, that you download using the following link, to demonstrate how you can load the treeview with the database objects of your choice AND only the database in the list:.

http://www.starprint2000.com/downloads/SmoBrowserDBOnly.zip

I have modified the code for procedure PopulateCollectionItems to check if the item to be loaded is a Database object and its name is in the list of names to be loaded.

Private Sub PopulateCollectionItems(ByVal node As TreeNode)
Dim oldCursor As Cursor = Me.Cursor
Me.Cursor = Cursors.WaitCursor
Try
For Each item As Object In CType(node.Tag, ICollection)
Select Case TypeName(item)
Case "Database"
If DatabasesToLoadList.Contains(CType(item, Database).Name) Then
node.Nodes.Add(CreateNode(item))
End If
Case Else
node.Nodes.Add(CreateNode(item))
End Select
Next
Finally
Me.Cursor = oldCursor
End Try
End Sub

Regards,

Joginder Nahil
www.starprint2000.com

|||

Fantastic!!

Thanks a lot for your very good reply and quick answer!

any tool which can tell the load of each database running on a SQL

is there any tool which can tell the load of each database running on a SQL
Server
Please reply asap
Thanks
Pankaj Jain
_________________________________________
Nagarro Software Pvt. Ltd.
3 Type B, Electronics City,
Sector 18, Gurgaon, India - 122015
http://www.nagarro.com
Phone (+ 91) 124 - 5016775, 2455301, 2455302, 2455303
Extn. 205
Fax (+ 91) 124 - 2455304
"This electronic communication and any accompanying document are intended
only for the individual or entity to which it is addressed and may contain
confidential and/or privileged information. If you are not the intended
recipient of this message, be aware that any use, review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error and/or are not the intended recipient,
please notify the sender and delete it from your system. We do not claim
that this information is complete or accurate and any views expressed in
this message are those of the individual sender."
Check this one: http://www.imceda.com/Coefficient_Description.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Pankaj Jain" <pankaj@.nagarro.com> wrote in message
news:eGVlTWnNFHA.2144@.TK2MSFTNGP09.phx.gbl...
> is there any tool which can tell the load of each database running on a
SQL
> Server
> Please reply asap
> Thanks
> Pankaj Jain
> --
> _________________________________________
> Nagarro Software Pvt. Ltd.
> 3 Type B, Electronics City,
> Sector 18, Gurgaon, India - 122015
> http://www.nagarro.com
> Phone (+ 91) 124 - 5016775, 2455301, 2455302, 2455303
> Extn. 205
> Fax (+ 91) 124 - 2455304
>
> "This electronic communication and any accompanying document are intended
> only for the individual or entity to which it is addressed and may contain
> confidential and/or privileged information. If you are not the intended
> recipient of this message, be aware that any use, review, dissemination,
> distribution, or copying of this message is strictly prohibited. If you
have
> received this communication in error and/or are not the intended
recipient,
> please notify the sender and delete it from your system. We do not claim
> that this information is complete or accurate and any views expressed in
> this message are those of the individual sender."
>
|||Hi
Thanks but i already saw this and i want some thing that gives me load in
percentage for all the database that exist in the SQL Server at that point
Thanks
Pankaj Jain
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OFUFLuoNFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Check this one: http://www.imceda.com/Coefficient_Description.htm.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Pankaj Jain" <pankaj@.nagarro.com> wrote in message
> news:eGVlTWnNFHA.2144@.TK2MSFTNGP09.phx.gbl...
> SQL
intended[vbcol=seagreen]
contain
> have
> recipient,
>
|||Hi,
Did you mean Load in terms of User connections for each databases, then it
is possible.
Select getdate() as Current_time,DB_NAME(DBID) as DBNAME,COUNT(*) from
Master..sysprocesses
Group BY DB_NAME(DBID)
You can schedule the script to execute using OSQL and save it in a fife.
This will give you the amount of users in each database. If needed you can
schedule this script using SQL Agent to run based on specific interval.
Thanks
Hari
SQL Server MVP
"Pankaj Jain" <pankaj@.nagarro.com> wrote in message
news:uKXIbxoNFHA.2520@.tk2msftngp13.phx.gbl...
> Hi
> Thanks but i already saw this and i want some thing that gives me load in
> percentage for all the database that exist in the SQL Server at that point
> Thanks
> Pankaj Jain
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
> message news:OFUFLuoNFHA.1176@.TK2MSFTNGP12.phx.gbl...
> intended
> contain
>

Any solution for that?

I've got a .dts which load data to several Sql2k servers by Copy SQL Server Objects Task. I'd like to add another task for a Sql25k but I can't because of it's requesting SMO.

It seems that such task need DMO. I know that there are other ways for do such stuff in that DTS but I wonder if there is any trick or shortcut for to avoid this barrier.

How odd, if you use Dts Import/Export Wizard from EM sql25k is accepted.

Any load testing tool to test queries

Guys,

Is there any tool that can test the scalability of Analysis Services?

Basically we want to fire multiple queries to the Analysis Services and check if there is any performance degradation.

Is there any utility or tool that I can use?

Rgds

Hari

SQL Performance monitor works with SSAS too.|||

The Community samples site has an ASLoadSim tool listed which might be worth a look http://www.codeplex.com/SQLSrvAnalysisSrvcs

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.Hi Hassan
"Hassan" wrote:
> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.html?
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
>> This is not just tied to disk space, but also CPU load, IO, n/w
>> throughput,etc.. Thank you.
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.html?
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.
Hi Hassan
"Hassan" wrote:

> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
[url]http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.htm l?[/url]
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John
|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> [url]http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.htm l?[/url]
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.Hi Hassan
"Hassan" wrote:

> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
http://searchwincomputing.techtarge...yr2005,00.html?
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
>
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> http://searchwincomputing.techtarge...yr2005,00.html?
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John