hey,

Elliott,

simple would be good! So at the moment its using dynamic ports so it would be something like sqlcmd -S 192.168.7.250:6575 (What ever port it says in SSCM...

Hi all so update

I changed the firewall rule to allow any ports to the clustered instances IP. Thinking this would get them connected in the first instance and...

New question has arisen today regarding clustering and connecting. Which is related to this so hoping you still reading these Elliot!

We have a VPN rule pointing to our old cluster...

Hi Elliot,

No im happy with clustering. What im wondering is,is sql server configuration manager cluster aware. IE if i create a alias in SSCM while the cluster is on Node...

Thanks elliot clears. Up everything except anew query on adding an aliase to a cluster. Are changes on sscm held on all nodes of a cluster.

Thanks to all that...

thanks for the replies!

aliases seems a good option if the app allows it! will play around with them Thanks!

I was mainly curious on weather when you create multiple...

thanks for all the quick replies!

I shall have a play!

Ok,

So i changed the account that runs SQLServer, SQLAgent to the AD account we use.

Then Added the use to the Lock Pages in Memory.

Then open SSMS right click...

Ninja's_RGR'us (5/9/2011)

---

The great thing about Michelle's script is the history. With further analysis I could spot ± 100 indexes that needed to be moved to 80 fill factor instead...

Thanks for input!

I will try to get grips with them this week!

S

Aprils about done and still no news 🙁

On a happier note. Mr Berry has been busy on hes blog doing a blog a day on hardware!

http://sqlserverperformance.wordpress.com

Thanks Gila,

I didnt think there would be an "Easy solution"

Thanks for the help

S

Only problem i have with that is..

we have no test/dev server..

we have live sql server and that is all :/

I could create a vm with 2005 on...

Update,

I rolled over the cluster to the other node and restarted that machine.

Memory is now running back at the 10gb mark.

the perfmon results show that the memory went...

Thanks for the quick reply!

S