SP 2010 - New Database for Reporting and Logging

Question

I ‘heard’  SP 2010 has a new member in database family. A dedicated database to capture, store and retain many of the logged events, extremely useful for reporting and analytics as well as a better consolidated store for information buried in ULS log files on WFE.

Who knows more about it and talk about it?

---

Aamir M Qureshi http://www.agileconcepts.com/blogs/aq http://www.linkedin.com/in/aamirq

Answer 1

I would also like to add on to this question, I have a co-worker at the conference that mentioned that he heard that there are about 5-7 database per site (I am assuming he is talking web application, he is just developer :)   ). Can someone Confirm or deny this, and maybe a quicl little list of what they are?

I had also heard rumors that the "reporting and logging" list do not fall within the "if you touch it you are not supported" rule. Has this (or is this ) changing for some or all the databases?

Thank you,

Answer 2

Part of Health and Reporting features is a logging database and you can create reports, etc based on the database.  You also have ULS Viewer that you can download from here. http://mysp.in/2s 

---

Alpesh Nakar Blog: http://alpesh.nakars.com/blog | Twitter: @alpesh SharePoint Resources: http://www.justsharepoint.com | Twitter @justsharepoint

Answer 3

The Logging database used by the Usage and Health Reporting service application will be extensible allowing 3rd parties and developers to surface data stored within it and generate unqiue and compelling custom reporting solutions based on the data contained therein.

Site collections can continue to reside within one or more databases (*) and follow the same basic principles of 2007; however, you will see additional databases as a result of both new service applications and changes to the approach of service applications such as Search where the databases are distributed and targeted at specific purposes and/or content.

Bill

---

Bill Baer

(*) A later correction from Bill was "Correct, a site collection cannot span content databases; however, a site collection can exist alone in a single content database or co-exist with other site collections within a given content database."

Answer 4

Site collections can continue to reside within one or more databases ...

I am guessing this is just a mistype, or wording different than expected. I don't believe a Site collection can span databases. You can have multiple databases per web application and multiple site collections within a database, but correct me if I am wrong, you can not have a Site collection that has more than one database.

I just wanted to clarify the wording.

Thank you,
Eric VanRoy

Answer 5

Correct, a site collection cannot span content databases; however, a site collection can exist alone in a single content database or co-exist with other site collections within a given content database.  ;-) Sorry, I should've worded that more clearly.

---

Bill Baer