Databases Reference
In-Depth Information
Figure 4-3
PerformanceDashboard
The SQL Server Performance Dashboard is a set of SQL Server Reporting Services reports written
by the SQL Server support team at Microsoft to take advantage of the Custom Reports feature available
in Service Pack 2. Custom reports allow you to add your own Reporting Services reports to SQL Server
Management Studio. The support team at Microsoft has provided a great set of performance reports
including the one on wait stats seen in Figure 4-5. Chapter 3 looks at the Performance Dashboard
in depth.
Wait Stats inAction
For demo purposes we've used the sample database described in Chapter 11. We've loaded the people
table with 250,000 rows and we're going to run a stored procedure called
usp_marriageUpdate
which
makes 10,000 ''marriages'' between these people by updating a girl's surname to match a chosen boy.
There are no indexes.
Search WWH ::
Custom Search