It's very slow for me when I login remotely to the server and start activity monitor. It takes forever to come up and display the info.

Thank you very much. I will try this but I have to wait until no one is using the server because I know that I will have to restart...

thanks buddy! 🙂

Okay. Thanks for replying. Do you have any DMV scripts that you use that you wouldn't mind sharing with me? That would be most appreciated.

Did anyone find out the answer to this? It is really slow and not good when you need to find out information quickly.

Thanks I will take a look at the link. As far as upgrading to SSIS, the developer has a learning curve so they want to upgrade to 2008 with...

Thank you. I am making progress. We are testing as we speak.

I will let you all know if I am successful here very soon.

Thanks.

Patti

Thank you very much. I will search out how to configure reporting services scaled out.

Patti:-)

Last question, when you connect to reporting services using the reporting services configuration tool, do you connect with the node name or the sql cluster name? In my case...

I failed the default instance that has the reporting services database setup to the second node. From node 2, I ran report services configurator and connected to node 1...

Is is required to have a scaled out deployment when you have sql server installed on a cluster?

Perry, I hope you are still around. I am really sorry that I couldn't respond sooner.

I have attached a txt file with all the answers.

Please let...

Sorry perry, I don't know that command.

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\164937>cluster /CLUSTER:edcluhouma NODE /STATUS

Listing status for all available nodes:

Node ...

Thank you. I will definitely do that and let you know.