If you're following the techniques described in the main article, you might want to simplify the process of connecting to the System Monitor—generated tables by using Microsoft Access data access pages to query the tables directly. However, you'll probably find that queries you create access unindexed data, making them run especially slow. Additionally, data access pages seem to have a bug; they won't accept the Connect Timeout property and instead use a default timeout of 30 seconds. So if you use data access pages to view System Monitor—logged data, you need to perform some data transformation to avoid the 30-second limitation. We suggest you create an alternate data repository in SQL Server in which you can store and manipulate the System Monitor data to suit your needs—and avoid the 30-second limitation.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish