SQLSentry Plan Explorer, *.pesession extension.

GokhanVarol 2013-03-14 14:26:50

Does that store any less or more information compared to *.queryanalysis extension?
How come it's size is a lot less than *.queryanalysis extension?
GregGonzalez 2013-03-14 22:43:17
Pesession files are simply compressed groups of queryanalysis files and a metadata file. If you change the pesession file extension to .zip (temporarily) you can open it and see this. Since queryanalysis files are are uncompressed by default, this explains the size difference.

We could probably compress queryanalysis files too. We'll discuss this. Thanks.