Load Balancing

need advice for below scenario

currently am having a active / passive cluster sql 2000 server, due to the amount of transactions am moving to new high end servers with sql 2005 cluster.

incase the new cluster also doesnt stands the load what approach i should use similar to load balancing.

with regards

alby peter

The same options are available that would be available for a non-clustered system. Perhaps you can split your data into two separate sets on two separate instances and use distributed partitioned views (DPVs) or perhaps Peer-to-peer transactional replication to work with the data on each instance. Perhaps data dependent routing (DDR) can be used to have your client connect to the instance that likely has the data you want, and linked servers and DPVs can be used to access data that's on the other instance (or split across the two instances).

Don

|||

Dear Don,

thanks for the response.

i read about the above solutions is this type of real time replication in practice for real time servers. in peer to peer transactional replication how many servers could be idle for the best result.

thanks in advance

alby

|||

Replication does have some amount of latency, and though it might only be sub-second, you do need to evaluate your real-time requirements. DPVs access the actual data in its original location so there's no latency there.

I'm not sure what you mean by 'how many servers should be idle' .. I'd think you'd distribute the data across as many instances as are appropriate to meet your retrieval requirements for the given hardware. If your idle servers are 'passive nodes' within a failover cluster, then that depends on the reliability of your hardware and how crippled you'd be if two (or more) of your instances had to run on the same node.

Don

Load Balancing

need advice for below scenario

currently am having a active / passive cluster sql 2000 server, due to the amount of transactions am moving to new high end servers with sql 2005 cluster.

incase the new cluster also doesnt stands the load what approach i should use similar to load balancing.

with regards

alby peter

The same options are available that would be available for a non-clustered system. Perhaps you can split your data into two separate sets on two separate instances and use distributed partitioned views (DPVs) or perhaps Peer-to-peer transactional replication to work with the data on each instance. Perhaps data dependent routing (DDR) can be used to have your client connect to the instance that likely has the data you want, and linked servers and DPVs can be used to access data that's on the other instance (or split across the two instances).

Don

|||

Dear Don,

thanks for the response.

i read about the above solutions is this type of real time replication in practice for real time servers. in peer to peer transactional replication how many servers could be idle for the best result.

thanks in advance

alby

|||

Replication does have some amount of latency, and though it might only be sub-second, you do need to evaluate your real-time requirements. DPVs access the actual data in its original location so there's no latency there.

I'm not sure what you mean by 'how many servers should be idle' .. I'd think you'd distribute the data across as many instances as are appropriate to meet your retrieval requirements for the given hardware. If your idle servers are 'passive nodes' within a failover cluster, then that depends on the reliability of your hardware and how crippled you'd be if two (or more) of your instances had to run on the same node.

Don

sql

LiveStats.XSP

We were running LiveStats.XSP 7.50 on our server and due to a server failure had to re-install.
However, after entering the license key and completing the install, the software still reports as being unlicensed.
What is the procedure to rectify this?

Thanks

That would be entirely up to LiveStats and how they handle their licensing.

I suspect that they tuck some license key into the database (or maybe Master/msdb?), but you really need to contact them.

|||the server name and port in DEEPMETRIX\analyzer\settings.xml needs to be working for livestats! you need to configure iis to accept connections on that host header and port or change the settings in the file.

<Licensing>
<Server>localhost:80</Server>
</Licensing>

there will be no connection from the internet, but there is a licensing app that opens a connection to the licensing server of deepmetrix and to the local instance of livestats. this service uses the above setting to post the license to the local instance.

the madcow|||Actually, it would be up to Microsoft to support the products they have purchased and pledged to support.sql

LiveStats.XSP

We were running LiveStats.XSP 7.50 on our server and due to a server failure had to re-install.
However, after entering the license key and completing the install, the software still reports as being unlicensed.
What is the procedure to rectify this?

Thanks

That would be entirely up to LiveStats and how they handle their licensing.

I suspect that they tuck some license key into the database (or maybe Master/msdb?), but you really need to contact them.

|||the server name and port in DEEPMETRIX\analyzer\settings.xml needs to be working for livestats! you need to configure iis to accept connections on that host header and port or change the settings in the file.

<Licensing>
<Server>localhost:80</Server>
</Licensing>

there will be no connection from the internet, but there is a licensing app that opens a connection to the licensing server of deepmetrix and to the local instance of livestats. this service uses the above setting to post the license to the local instance.

the madcow|||Actually, it would be up to Microsoft to support the products they have purchased and pledged to support.

LiveStats.XSP

We were running LiveStats.XSP 7.50 on our server and due to a server failure had to re-install.
However, after entering the license key and completing the install, the software still reports as being unlicensed.
What is the procedure to rectify this?

Thanks

That would be entirely up to LiveStats and how they handle their licensing.

I suspect that they tuck some license key into the database (or maybe Master/msdb?), but you really need to contact them.

|||the server name and port in DEEPMETRIX\analyzer\settings.xml needs to be working for livestats! you need to configure iis to accept connections on that host header and port or change the settings in the file.

<Licensing>
<Server>localhost:80</Server>
</Licensing>

there will be no connection from the internet, but there is a licensing app that opens a connection to the licensing server of deepmetrix and to the local instance of livestats. this service uses the above setting to post the license to the local instance.

the madcow|||Actually, it would be up to Microsoft to support the products they have purchased and pledged to support.

List all Stored Procedures used in a VS.NET project

Hi

This is kind of a visual studio question, but pertinent to db' s - due to many changes of our application I know that there are many stored procs in the database that are no longer used. Since I cannot get a list from the programmers, is there any way to get a list out of visual studio, of every SQL stored procedure called in that project? (Going through each form manually will just be too time consuming for me or the programmers)

Anyone know any tricks??
thx
Desthis query can list all the stored procedure names that ur db has...

select name from YOURDBName..sysobjects where xtype='P'|||Sorry, you misundertand - I need to list the procs used in a Visual Studio project, not in a DB..(as I know a lot are not used anymore and want to clean out my db)