SQL Server administration script

$30-250 USD

In Progress

Posted

almost 8 years ago

$30-250 USD

Paid on delivery

We are in SQLServer 2012 environment. Need some help to create a procedure that will kill blocking SPID for a particular database ( say the database name is mydb ) by a specific login ( say domainname\username ) if this login blocks mydb process for more than 5 min. We found that a particular login which is performing read on the database is blocking the load process for the same database. We want to execute the proc every 15 min to kill any blocking SPID.

Database Administration

Microsoft SQL Server

SQL

Project ID: 11058181

About the project

3 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

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

3 freelancers are bidding on average $133 USD for this job

@hardikshah83

Programmer with more than 10 years of experience here, can execute this task to perfection.

$100 USD in 1 day

4.9

(30 reviews)

5.7

@jagdishbhatt38

I am having more than 7 years of experience in IT industry.I have worked on .net(c#,asp,asp.net,mvc) with sql server and oracle.I can provide you better solution by utilizing my knowledge and skills.

$144 USD in 2 days