Thank this author by sharing:
By Russ Mulkey,
Do you load .csv files into excel from perfmon (blg files)? I took Brent Ozar's suggestion to add the min, max, and average functions. Thanks Brent! However, I wanted to know when (time of day) the counter hit the min and max values. For example, what is the excel cell address of the absolute value of the max function? In Figure B below the counter "\SQLServer:SQL Statistics\Batch Requests/sec" occurred at 10:30PM. No, it's not a screamer.
The steps I took:
Be careful when copying cell contents and using relative or absolute cell addresses. e.g. B1 vs $B1 vs B$1 vs $B$1
Figure A. Excel layout manual
Excel graphic of perfmon data. Note the data range's don't match. Pretend data range B8:B85496 is really B8:B788 and it's all good again.
You can also get min and max values and time time of day by sorting / filtering. I found this to be too much clicking around. Yet another way to do this is to load it into a MSSQL table. So many ways and so little time. There are some really great authors that I've learned tons from. However, I cut my teeth with SQL Server Central.
Cheers! I will drink to that.
Comments posted to this topic are about the item [B]Excel Function Returns Cell Address[/B] I may ju...
Running perfmon 24x7
Can a scalar SQL function be used instead of Excel formulas?
Help with average calculation
Average across time/overall average
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.