SQL Server Performance Forum – Threads Archive
Installing an extended SPHi all! I want to install an extended SP onto my active/passive cluster (namely this one:http://anmar.eu.org/projects/ctnhashproc/) I read that you need to install it on a ‘shared disk’ in a cluster otherwise it won’t work if the cluster fails over. Would I just need to do something like this, where D: is a drive on the SAN that belongs to the current active node.
sp_addextendedproc ‘xp_ctnhash’, ‘D:SomePathxp_CTNHashProc.dll’
Also, are there any other things I have to be aware of before installing an extended SP onto a cluster? Thanks! Kristi
I;m not aware of any issues in using these extended SPs in clustered environment at my end. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Can you post the link where you’ve read this? —
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)
you need to intsall the extended stroed procedure to both of the base nodes to keep it working when failover happens. Thanks N’ Regards