Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Archurch
Starting Member
3 Posts |
 Posted - 2007-05-02 : 16:36:40
|
| Hi all,After installing SP2 for SQL2005, My boss has found new reports when looking for database information. Specifically, the new Reports option when right clicking on a database.To better streamline our dbs he found a pair of Index reports that he does not know what to do with. Can anyone help us understand the time length for the numbers shown under #User Seeks, #User Scans, #User Updates, Last User Seek Time, Last User Scan Time, etc..?We are unsure if these are daily, or from the last backup, or for uptime since last restart, or collected from the inception of the database.Any help would be good and very much appreciated as I am VERY new to this and would like to show that I can find information when asked. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 22:52:40
|
| Since last restart, Kalen Delaney had article of it on sql server magazine. |
 |
|
|
Archurch
Starting Member
3 Posts |
Posted - 2007-05-03 : 13:16:22
|
| Hi,Thanks for the quick feedback. One of the programmers has a subscription to SQLServer magazine and I have grabbed as many copies as I could find. Since I want to "learn to fish", how could I have looked up this article or found information about it?I see that many articles have the author and INSTANTDOC ID. Is there a way to use these infobits to sort, find, and soak-in information to use on my own?Robert Church (SQL neophyte and growing..) |
|
|
|
|
|
|
|
|
Need column definitions for new SP2 Reports