October 3, 2007 at 5:29 pm
I need your valuable suggestions on the following :
What are the different aspects that I need to consider in optimizing the existing data model/datamart ?
When asked for a study on existing data model what are the different aspects I need to focus on ?
These seems to be a general question. But it is very useful for me to explore and present in a little span. So all your suggestions are very valuable for me.
October 3, 2007 at 5:43 pm
Search this site for performance tuning. You'll get at least 200 hours worth of reading. After you've done that, start tuning a few 1000 queries. Somewhere in that process, you'll start to get the hang of it.
October 3, 2007 at 8:53 pm
What do you mean by optimize? You need to have some sort of idea of what you're trying to achieve in order to begin. There isn't any general way of optimizing things as changes to make one thing better might make another worse.
October 4, 2007 at 6:52 am
If you've got an existing system, monitor it to see what, if anything, is behaving badly. Start from there. Once you've identified the issues, you can start to make decisions about solutions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 4, 2007 at 8:28 am
As the typical answer on here goes...."it depends". On lots of things.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 5, 2007 at 8:22 am
Madhura I strongly recommend either taking a class or hiring a professional to give your systems and apps a performance review - or both!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 11, 2007 at 5:55 am
you can start with the DB Tuning Wizard that comes with SQL Server.
October 11, 2007 at 7:16 am
I strongly advise clients to stay away from the Database Tuning Advisor. I know some have had some success with it, but I have seen it absolutely destroy database performance.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 11, 2007 at 7:19 am
I wasn't going to comment on the Tuning Advisor, but since the gate is now open... I haven't had good experiences with the Advisor either. I haven't had it ruin a system or anything, but I've never found it to actually deliver useful recommendations. Hours collecting data and feeding it in to the system only for it to suggest a couple of odd indexes that when tested actually didn't change the performance an iota. It just wasn't worth the work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 11, 2007 at 8:05 am
I haven't really used the advisor in 2005, but it didn't work well in SS2K. Bad suggestions, took too long to run, just stays away.
Go with one set of tables at a time. Work through related tables for queries that are giving you issues.
Post some more details and we'll help.
October 15, 2007 at 4:01 am
I use the DTA for individual queries, for a complex query it's usually quicker at working out the answer than I am ! I figure it and I generally get the same results ( for basic indexing ) with myself being able to do better about 25% of the time ( however I only tend to use it on big complex queries that are more difficult to unravel by hand )
It does crash quite often too. It's way better than sql2k though. I doubt if it's the solution to this post though.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply