Thanks for the responses. I am looking for something like an automated kind where as and when the database state is other than 'ONLINE' , DBA team should be notified...

Hi,

Getting below error messgae when I execute it at powershell command.

PS D:\>

PS D:\> $Computer = "WIN7-PC"

PS D:\> Get-WMIObject Win32_Volume -Filter "DriveType=3" -Computer $Computer | Select SystemName,DeviceID,VolumeName,FileSyst

em,BlockSize,NumberOfBlocks,@{Name="size(GB)";Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace(GB)";Expression={"{0:N

1}" -f($_.freespace/1gb)}},@{Name="freespace(%)";Expression={"{0:N1}" -f(($_.freespace/$_.size)*100)}})

Unexpected...

Hi,

Thanks for the script. I installed powershell on one of my windows 7 machine. However, i am getting below error.Not sure, If I am using right command line....

installing powershell do we any security risks as mine windows 2003. am not sure we can download sdk which has powershell 2.0.

can u share the script?

If there is no database mirrorning implement and incase i cannot implement mirroring on all databases on production , i such a scenario what would be the best way to...

Thanks Gail for sharing those links. Thank you.:-)

Thanks very much for the pointer.

Thanks a ton.

Thank you. It was database mails which is failing.

Thanks a lot.

Thank you.

Hi,

Thanks for sharing your thoughts.

Gila, I have a question, how does the calucation comes to 16Gigs If I have to choose /PAE + /3GB + AWE ?

Thank you.

Hi Gus,

I am just testing/learning memory concepts over here. not to throttle any productions systems 🙂

Nothing. Just wanted to reproduce the issue and see the performance counters. Doing some reading Memory....

Do you have any steps to reproducing the error?

Hi Gus,

I wanted to reproduce the below errormsg. I was able to inflate the sql memory. But i need someother process or exe which blot the memory and results in...

Hi Thank you.

I am looking for T-sql script which will use up memory so that i can monitor which process is eating up most of memory.