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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2012-06-28 : 21:54:08
|
| Can anyone Please Explain to me the The knowledge of the Performance Report which is generated on the VALUES provided and how to ANLAYSE these values for the following and deduce as SUMMARY.I couldn't paste the whole report but this is based on several paramenters such as:AVERAGE READS:SUM READS:SUM READS:Example:SQL StatementSELECT dbo.fnSpace_DHPDS_Export_ExtractProcess(N'?' ) AS ResultExec's -3Reads (8kb I / O)Total - 28,372,161 Average - 9,457,387Duration (ms) Total - 98,828,072 Average - 32,942,690 CPU(ms) Total - 95,583 Average - 31,861Your TIPS would be highly appreciated.Many Thanks |
|
|
|
|
|
Performance Analyse