extended stored procedures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello!



I have a difficult situation with a clustered server. It consists of two
parts - Cluster_1 and Cluster_2 computers with WINDOWS Server2003. Cluster_1
and Cluster_2 are with 6 GB RAM.

The whole clustered server is named Cluster.



SQL Server 2000 is installed on Cluster.

Service Pack 4 for SQL Server 2000 is installed and latest hot-fix KB899761
is installed too.



I have some extended stored procedures implemented in xp_parser.dll.

One of those is - lets say xp_MyProc.

The problem is - when I call xp_MyProc, the returned result is correct, but
the execution time is extremely long.



xp_parser.dll is placed in C:\WINDOWS\System32 on both Cluster_1 and
Cluster_2.

The shared hard disk between Cluster_1 and Cluster_2 is F:

A copy of xp_parser.dll is not located on F:



What is the cause of the extremely long execution time of xp_MyProc?

When I call xp_MyProc for second and third time - the situation is not
better.



Thank you!


.