on 2015 Mar 04 11:09 AM
The scenario is a customer testing the move of a database to a new server / SAN.
The new server has 2 x 24 core Intel Processors, 192 GB RAM, Windows 2012 Server. SAN is EMC all SSD system connected by fibre channel.
Database engine is 16.0.0.2076 - the 72GB database file is in 11.0.1 format still. 4k page size. 50GB allocated to DB cache.
If the database is copied straight over and started under v16 general performance is good. However given the change in hardware we thought it would be worth running CALIBRATE SERVER. After doing this the general responsiveness of the system was very much slower - seemingly across all queries and some heavy duty processes have gone from seconds to minutes. Running RESTORE DEFAULT CALIBRATION made things better but definitely not as good as before.
IOParallelism remains at 1 at all stages. Running sa_unload_cost_model() before the CALIBRATE SERVER produced an empty file. After the calibration it produced a file with content, and after the restoration of the default calibration it produced an empty file again.
My questions:
Content of the cost model file mentioned above was:
1,0,2,0x0700000001000000c800000020030000800c000004d04c00e89c9900b036330192000000d5000000de000000e10000006d0100006f0100006f01000092000000d5000000de000000e1000000db000000dc000000d9000000400d0300
Request clarification before answering.
User | Count |
---|---|
82 | |
29 | |
9 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.