sql server 2012 slow

I have a new server which is slower than the one it is replacing.  It's a vm and my network services team is pretty stingy with handing out processor and ram without it being justified by bill Gates or google.

my setup is 2012 operating system and sql s2012 also.  I have some counters on perfmonitor going but not really sure to make of all if it.  Can someone tell me the tests to run to figure out if there is a bottle neck depended on a hardware resource.
jamesmetcalf74Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan McFaddenSystems EngineerCommented:
What was the old server resource configuration?

1. Was it physical or virtual?
2. # of CPUs?
3. # of cores per CPU?
4. How much RAM?
5. Did the old server have a RAID controller?
6. How many HDDs and how were they configured?
7. how many instances of SQL?
8. how much RAM did the (or each) RAM have allocated?
9. Where were the data files (mdf) stored?
10. Where were the log files (ldf) stored?
11. How much pagefile.sys space was configured?

What does the new VM have for resources?  Same questions as above...

Plus, what is slow about the new sql instance?

Dan
jamesmetcalf74Author Commented:
Jeez dude-
I'm going to have to get to work on that request.  I don't have access to all that info at this time.

in the meantime...
is there any easy way to make the sql server work?  some sortof innoucuous query that will make my counters go up and see what is pegging.
Dan McFaddenSystems EngineerCommented:
Sorry but those questions will help determine whether or not you've purchased and/or configured your new server properly.  Each question has to do with sizing a server correctly for the job it will perform.  And I still have a few more that I didn't throw out there...

In addition, you need to know how SQL Server Engine was configured.

To run a test on your SQL instance, you could do the following:

1. create a new database on the upgrade server
2. in the newly created database, create a new table
3. add a number of fields to the table, I usually add 5 to 10 fields
4. then you can use either a script or use the SQL Server Management Studio (SSMS) tool to run a query that will add a bunch of rows to the table... I usually run a 1,000,000 records to the database and time the execution of the job.

But all this will do is verify that SQL is running and give you an idea of how long it will take to dump a bunch of data into the db.  You would also need to run something like this on the old server and compare the resulting execution time.  This is an extremely simple test, its not intended to be the end-all-solution.

In a normal server upgrade cycle, you would document the exist server hardware configuration and the OS configuration.  You would also document, in detail, what applications are running on the server as well as how they are configured.  Not doing this makes it hard to get a baseline on performance and makes it very hard to properly size a new server...whether physical or virtual.

Here is link to Microsoft about what to monitor in SQL 2012 during operations:

https://msdn.microsoft.com/en-us/library/ms190994(v=sql.110).aspx

Dan

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.