May 5, 2015 at 9:58 am
Tom, I'd suggest that you check out Brent Ozar's First Aid sp's. They pack a lot of information that tells you a lot about what's odd about your system.
http://www.brentozar.com/first-aid/
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 5, 2015 at 10:16 am
Thanks Wayne, I am using Brent's tools and some of Ola Hallengren's maintenance solution. The app was not done with much awareness of SQL design methodologies, platform and maintenance configuration best practices. Consequently things are coming to critical mass and not working well... trying to start the bilge pumps before it turns into a submarine
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 5, 2015 at 10:32 am
Tom,
I am a developer in the same situation. I used a third party tool that was called "ignite", solarwinds owns it now. They have a free version (I never tried that) and a pay version with a 14 day free trial. This really helped me get the "low hanging fruit".
The URL is: http://www.solarwinds.com/downloads/
the options on the above page are:
For the pay version,
Section: Database Management Software
OPTION: Database Performance Analyzer for SQL Server®
For the free version,
Section: Free Database Management Tool
OPTION: Database Performance Monitor
Hope it helps!
-Karen
May 5, 2015 at 10:54 am
Thanks Karen - much appreciated.
I doubt there is just one 'magic bullet' but - this really seems like a market opportunity to build an astute tool that asks the right questions and offers a set of scripts and verifications.
...maybe in my spare time, in a perfect world
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2015 at 1:04 am
Another free ebook that may be useful is The Accidental DBA
If you are using Ola Hallengren scripts that's a good sign that backups are in place, but make sure that they are and that the database is in a suitable recovery mode. Lots of indexing will increase your file sizes.
If you are using the database tuning advisor, give it a fulll worload from profiler not just an individual query, because it only knows about the workload you give it, so you can end up with lots of duplicated indexes if (like some developers I know) you take every recommendation - I have found a table with over thirty indexes and about 30% are duplicates with maybe a different included column! And every index adds an overhead when you add/change/delete the data.
I use the performance dashboard reports as another starting point, exporting the results to Excel.
May 6, 2015 at 5:35 am
Thank you very much all who have responded !
- data is fun, but gotta learn the rules to make it work for you, or you work for it
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply