April 5, 2016 at 10:39 am
Hi, My first post here seeing as how I became the accidental admin for our databases.
Learning a lot the last few months, but I believe I have an performance issue with our new server...
We recently moved our SQL Database from an old HP ML350 to a DL380p G8 running Server 2008 R2 Datacenter and SQL Server 2008 R2 SP1. The HP DL380p is loaded w/ 2x 2.9GHz E5-2690 CPU's, 192GB Ram and filled with SSD drives totaling 1.5TB of space. (Note: these drives are only 3Gbps models)
We have about 12 users accessing the DB thru an application (Sixbit) used to list items on eBay.
I was advised by the Sixbit dev's that I should move the listing pictures out of the dB and into their own folder on the C: drive of the server to improve overall performance and response time of the app..
I did this over the weekend,, and although scrolling thru the windows grids have improved slightly, it wasn't a "Oh Wow" moment... And although it took a bit for the application to open, it takes 2min:12sec on average for the app to open after logging in..
Also, Everything in our network is gigabit and most users are in the (Workgroup) network, while others are logging in thru doamin accounts.. Performance is the same on from both networks
I researched all the info I could (and comprehend) about performance tuning,, and I've watch the resource monitors. Nothing is really being maxed.. But I just do not understand it well.
The first thing I'd like to verify are the Processor Settings in SQL.. Pretty sure everything was set to default..
Dropbox Screenshot HERE
Any advice and guidance will be greatly appreciated..
Chuck
April 5, 2016 at 10:52 am
c_wager (4/5/2016)
Hi, My first post here seeing as how I became the accidental admin for our databases.Learning a lot the last few months, but I believe I have an performance issue with our new server...
We recently moved our SQL Database from an old HP ML350 to a DL380p G8 running Server 2008 R2 Datacenter and SQL Server 2008 R2 SP1. The HP DL380p is loaded w/ 2x 2.9GHz E5-2690 CPU's, 192GB Ram and filled with SSD drives totaling 1.5TB of space. (Note: these drives are only 3Gbps models)
We have about 12 users accessing the DB thru an application (Sixbit) used to list items on eBay.
I was advised by the Sixbit dev's that I should move the listing pictures out of the dB and into their own folder on the C: drive of the server to improve overall performance and response time of the app..
I did this over the weekend,, and although scrolling thru the windows grids have improved slightly, it wasn't a "Oh Wow" moment... And although it took a bit for the application to open, it takes 2min:12sec on average for the app to open after logging in..
Also, Everything in our network is gigabit and most users are in the (Workgroup) network, while others are logging in thru doamin accounts.. Performance is the same on from both networks
I researched all the info I could (and comprehend) about performance tuning,, and I've watch the resource monitors. Nothing is really being maxed.. But I just do not understand it well.
The first thing I'd like to verify are the Processor Settings in SQL.. Pretty sure everything was set to default..
Dropbox Screenshot HERE
Any advice and guidance will be greatly appreciated..
Chuck
What you need to do is identify where the performance problem is. If it is in sql then you need to identify which queries or procedures are causing issues. Then you need to look at the execution plans for those queries. It does NOT necessarily mean that resource usage will skyrocket (although it could). It could be stale statistics or a whole host of other possibilities.
Figure out where the performance is problematic and try to isolate what is slow.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 5, 2016 at 11:15 am
.. I was advised by the Sixbit dev's that I should move the listing pictures out of the dB and into their own folder on the C: drive of the server to improve overall performance and response time of the app..
I did this over the weekend,, and although scrolling thru the windows grids have improved slightly, it wasn't a "Oh Wow" moment... And although it took a bit for the application to open, it takes 2min:12sec on average for the app to open after logging in ..
Describe the steps involved in the process of moving images out of database and into a folder.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 5, 2016 at 12:00 pm
April 5, 2016 at 12:02 pm
April 5, 2016 at 12:37 pm
Hi Eric,
I tried to reply posting the link to the Sixbit webpage but it apparently it was removed here..
You could google "Sixbit Picture Storage".. But at any rate, There's an option in the application to move the pictures by clicking a button.. A wizard walks you thru the process.. They suggest leaving the suggested defaults, which is creating a folder on the c drive..
April 5, 2016 at 12:52 pm
You need to identify the slow queries and fix them. No silver bullets here, no magic solutions. Most performance problems are bad code and/or bad indexes (usually both)
This article's dated, but should get you started.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 2:31 pm
Thanks Gail!
I working through Part 1 now!
Chuck
April 6, 2016 at 2:33 pm
I experienced this after my first migration.
I moved a database to new fast hardware but the speed seemed the same or worse.
I ran DBCC UPDATEUSAGE and SP_UPDATESTATS against the database.
It made a significant difference...now I include these after all migrations.
Wouldn't hurt to try.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply