We help IT Professionals succeed at work.
Get Started

Shared drive's performance vs local drive : to test SQL script's runtime

70 Views
Last Modified: 2015-11-23
In a previous maintenance window, I ran an SQL script given by our
principal to update DB schemas & this run took double the amount
of time catered for our downtime.

I'll need to run this script on yet another MS SQL database which is
about four times larger than this last database so I'm required by the
CAB (Change advisory board) to test this on a staging MS SQL VM
(which has SQL Mgmt Studio & MS SQL softwares installed)

However, I have hard time justifying to add a 320GB LUN to this test
server: instead there's another VM (let's call it VM B) n the same subnet
as this test which has 320GB of free space (also FC disk):

I'm exploring the options,

Q1:
If I share out this VM B's drive to my test server (which has MS SQL &
Mgmt studio installed), restore from tape the DB's backup into it , will
running the SQL script to update this 'test Db over the LAN' give us an
estimated run time that's quite close to having the test database sits
in a local drive (FC disk)?  

This VM B & test servers are both FC disk

Q2:
Suppose I install SQL Mgmt Studio on this VM B (which does not have
MS SQL server running it it), is it sufficient to run the MS SQL script
or I'll still need to have MS SQL software installed/run on it?

Q3:
I thought of getting our DBA to export out a dump of the production Db
& build a new DB: is this likely to be faster than restoring the production
Db into a test environment?
Comment
Watch Question
Senior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
This problem has been solved!
Unlock 2 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE