July 3, 2014 at 9:16 am
Hi,
When DBA's partition tables, what are some of the things they look at to determine the number of partitions, files, file sizes, and file groups.
Thanks
July 3, 2014 at 9:21 am
The first thing would be what the point of the partitioning is
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
July 7, 2014 at 8:18 am
I have a 14 million record table that gets frequent updates, inserts, and reads from reports. I'm trying to find a way to improve the performance and reduce blocking\locking. Ideally we should probably separate OLAP and OLTP but business is not willing to spend the money. Thanks.
July 7, 2014 at 8:52 am
Then don't waste your time looking at partitioning. Indexing along with tuning the queries should be your approach there.
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 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy