<div>
Yes you are right. The MS SQL Server Report Pack for IIS is a set of 12 Microsoft SQL Server 2000 Reporting Services reports that works with a sample database of information extracted from Microsoft IIS log files. <br />
<br />
You need to download and install it on your PC. You can find more information here:<br />
<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=2805d337-14c7-40e3-820b-e7ee653c68c0&DisplayLang=en" rel="ugc">http://www.microsoft.com/d<wbr />ownloads/d<wbr />etails.asp<wbr />x?FamilyID<wbr />=2805d337-<wbr />14c7-40e3-<wbr />820b-e7ee6<wbr />53c68c0&amp;Di<wbr />splayLang=<wbr />en</a> <br />
&nbsp;<br />
Please let me know if you have any question.<br />
<br />
Thanks<br />
Ganesh<br />

</div>


<div>
I am looking for one that is based on the perfmon counters; I am aware about the ones available for the IIS Logs that is within the 'Reporting Pack'
</div>


<div>
Your first question was: &quot;I was curious to find out whether there are any existing reports available for doing something similar for perfmon logs?&quot;<br />
Now you are &nbsp;looking for one that is based on the perfmon counters.<br />
<br />
<br />
Can you please explain your question again? <br />

</div>


<div>
Yes, I am looking for reports that based on the perfmon counters. Do you know of any? I am tracking common counters like %cpu time, % privileged time, Interrupts/sec (System), Pages/sec (Memory), ASP.NET Request/s, Request Timeouts, Requests Execution time..
</div>


<div>
The link you pointed me to, seems interersting; after running the script provided by M$oft, it has created a schema and some SPs. However, I do not see any tables related to this schema. Where could I find them?
</div>


<div>
They don't produce tables but scripts against your databse and you run the reports from SMS. 
</div>


<div>
Ones you runthe scripts connect in SMS Open your summary Window ; View &gt;&nbsp;F7, look for Rports tab and then you will see the rports ready to view all ready to go.
</div>


<div>
If you have any difficulty seeing them, let me know and I'll throw together a screenshot ...
</div>


<div>
Here is the screenshot just in case ...Have Fun ! ....There are approximately 23 Amazing Reports now all installed for you if you completed the download install and ran the scripts as the instructions said .......<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/07_w29/42753/Performance-Reports-Menu-Screens.doc" target="_blank" class="file-inline" title="Performance Reports Menu Screen (292 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Performance-Reports-Menu-Screens.doc</a>
</div>


Performance-Reports-Menu-Screens.doc

<div>
How do I navigate to the Summary Window where the &quot;Reports&quot; tab shows up? I am using SQL Mgt. Studio with a SQL Server Standard Enterprise configuration. If I click F7 or I go to the View menu I do not see the summary window.<br />
<br />
However, as I mentioned, I do see the schema for the Performance Dashboard and the scripts; so the install was successful.
</div>


<div>
I should mention that if I can get this going on the SQL-Server m/c, at least the main performance dashboard report is something I can use!
</div>


<div>
<ol type="1">
<li>Open SQl Server Management Studio </li>
<li>Connect To Your Database</li>
<li>Highlight Your Database You want to See (Will Work on any Of Your Databases) </li>
<li>Press F7 Or View &gt;&nbsp;Summary Window From the Tool Bar </li>
<li>And You Will Then See The Window Like In The Screenshot</li>
</ol>
</div>


<div>
Thanks for being patient; I have attached a pic of the &quot;SQl Server Management Studio &quot;. I do not see a summary window in the View Menu and also clicking F7 does not bring up anything.<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/07_w29/42838/SMS.JPG" target="_blank" class="file-inline" title="SQL Mgt Studio (67 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SMS.JPG</a>
</div>


SMS.JPG

<div>
Hight Light Your Database First then View F7
</div>


<div>
Sorry ...I mean Highlight Your Server Then View Summary Window F7 Will Auto Show ...
</div>


<div>
Reports Tab In Summary Window Instructions / Screenshot Attached ...<br />
If it helps furher This link will help get you around SSMS easily ... pretty explanatory ...<br />
&nbsp;<a href="http://msdn.microsoft.com/en-us/library/ms174168.aspx" rel="ugc">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/ms1741<wbr />68.aspx</a> <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/07_w29/42840/Reports-From-Summary-Window-In-S.doc" target="_blank" class="file-inline" title="Reports From Summary Window In SSMS (303 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Reports-From-Summary-Window-In-S.doc</a>
</div>


Reports-From-Summary-Window-In-S.doc

<div>
WOW! I have located it after some frustation. Again View summary did not show up in the View menu, but I could located the reports by right clicking (using the context menu) and navigating to Standard Reports. The first report is Server Dashboard. This will at least help me with the database server. Thanks!
</div>


<div>
Thanks for being patient; it will help me with at least with the database server
</div>


<div>
<div class="content wysiwyg-content">
I have set up perfmon to track several performance counters for a few web servers; I &nbsp;use scripts to log the data to a SQL Server database. I am aware that Microsoft has a 'SQL Server Reporting Services Pack' that &nbsp;has sample reports for reporting on IIS Logs.<br />
<br />
&nbsp;I was curious to find out whether there are any existing reports available for doing something similar for perfmon logs?
</div>
</div>


I have set up perfmon to track several performance counters for a few web servers; I  use scripts to log the data to a SQL Server database. I am aware that Microsoft has a 'SQL Server Reporting Services Pack' that  has sample reports for reporting on IIS Logs.

 I was curious to find out whether there are any existing reports available for doing something similar for perfmon logs?

Are there reporting templates (rdl) available for monitoring perfmon logs

The Domain Name System (DNS) is a hierarchical, globally distributed system responsible for associating the name of a computer, service or other resource into an IP address for connecting to the Internet or a private network. Most prominently, it translates domain names to the numerical IP addresses needed for the purpose of computer services and devices worldwide.

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.