Need to test performance on database
I am trying to test data compression and partitioning. I need queries I can run against the database and test performance before and after changes.
May 15th, 2015 10:12pm

 if you want to use these features and see how it benefits your database - should you not test in your database

but how would we know what your table structure is?  we need to know you partition key - partition function etc..

more importantly, we need to know how you query the data - so, we can tell whether partition works or not??

your best bet is to refer to this link 

https://www.simple-talk.com/sql/database-administration/partitioned-tables-in-sql-server-2005/

http://www.databasejournal.com/features/mssql/partitioning-in-sql-server-part-1.html

http://www.brentozar.com/sql/table-partitioning-resources/

http://www.sqlshack.com/database-table-partitioning-sql-server/

Database compression : you can test net storage savings you would get before implementing this but this help reducing CPU or consume higher CPU depending on the type of workload. refer this links https://technet.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

 http://sqlmag.com/database-performance-tuning/practical-data-compression-sql-server

http://www.mssqltips.com/sqlservertip/1582/implementing-data-compression-in-sql-server-2008/

Free Windows Admin Tool Kit Click here and download it now
May 16th, 2015 12:14am

Partitioning is more for manageability , archiving and etc... 
May 16th, 2015 3:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics