Category: SQLServerPedia Syndication

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I support.  In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter “Available Mbytes” a lot. Various references state that this value should be between 150 and […]

Professional Etiquette When Sending Mass Email – Use BCC:

<begin soap box rant> Time and time again I find myself having to email people to remind them about how and when to use BCC when sending out correspondence to a huge group via email. The main rule of thumb I tell the senders is that if dialog is not needed between everyone on the […]

Cannot create Cluster – the computer X is joined to a cluster

Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The computer xxx is joined to a cluster”.     My first thought then was to […]