May 4, 2017 at 5:56 am
Hello.
I have 4 instalations:
10.50.6220.0 (2008R2)
11.0.5556.0 (2012)
12.0.4100.0 (2012)
12.0.5000.0 (2014)
The four are differents in number of cores, ram, SAN and workload.
This DMV works fine (0.01 - 0.1 seconds per table), but in 12.0.500.0 works very poor (average 0.5 seconds)
His workload is less than the other three instalations.
some idea for this?
Thanks.
May 4, 2017 at 6:02 am
What parameters if any are you using and what is the size of the data returned ?
May 4, 2017 at 7:54 am
Hello RandomEvent.
The 4 instalations have the same application.
The parameters are id from database, id from table, id from any index and default for partition.
Few rows for execution (usual, one row, it is a OLTP, all tables with PK but only a few tables with more index).
More or less, DMV returns 346 bytes per row.
Thanks.
,
May 4, 2017 at 11:53 am
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply