Powershell

Closed Posted 5 years ago Paid on delivery

₹750-1250 INR / hour

Closed

In WFC a shared disk device has a dependency to a cluster resource like SQL Server. With the introduction of CSV (Cluster Shared Volumes) this dependency isn’t there any longer, because we assume that a CSV is always there. That’s right (sometimes), but if a SAN failure happens, the CSV or several volumes presenting the CSV will gone and SQL Server will start again. Ths brings SQL Server in an unpredictable situation and happened.

So we like to have a PowerShell-Script (running on every node on the cluster) monitoring the CSV and stopping the group hosting the SQL ressources if CSV failures happens.

CSVMonitor is a prototype … to show that this approach will general work.

Microsoft SQL Server Powershell Shell Script Software Architecture SQL

Project ID: #16946136

About the project

2 proposals Remote project Active 5 years ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

2 freelancers are bidding on average ₹1388/hour for this job

nikhiluk's Profile Picture
nikhiluk

Hello, Are you looking for monitoring script in powershell to check CSV is up, if failure happen ,Sql server resource group take to offline mode(so failover will not happen).Pls ping me to discuss exact requirement.

₹1388 INR / hour
(1 Review)
1.7
Post a project like this