January 4, 2012 at 8:07 pm
I haven't had much experience with table partitioning in sql server in general. I'm looking for some feedback regarding this. Not just table partitioning in sql server 2008, but, in general. I've done some reading about some of the new features of sql server partitioning in 2008, but, should I explore other ways(i.e. changing the clustering index) to enhance the performance of some of our large tables. Your opinions are very much appreciated.
Thanks in advance!
January 5, 2012 at 2:03 am
Is there a question here?
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
January 5, 2012 at 4:41 am
I think we need to have a bit more information in order to form an opinion. Partitioning can indeed improve the performance of a system but so can many other areas of Tuning.
If you can be a bit more specific as to what you're trying to achieve then we may be able to help further 😉
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
January 5, 2012 at 12:54 pm
Sure, first of all the database was initially setup by developers who have had no data modeling experience, so the database vary flat. The main table is approximately 8 million rows and this is
really the main table in the database and almost every query invokes this table. The idea is to segregate the data in such a way to reduce the amount of contention and improve performance.
At some point the entire database needs to be remodeled but that would mean changes to the tsql and they don't want to venture into this right now. We also get a fair amount of application timeouts
not deadlocks.
January 5, 2012 at 1:56 pm
Ok, so what are you after?
Partitioning can improve performance, but it's far from an automatic thing, depends on how queries are written, how the data is split up. The more common use for partitioning is maintenance.
If you want any useful help, you're going to have to be a lot, lot more specific, or hire a consultant for a few days to do a full analysis and recommendation.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply