 |
Return Create A Forum - Home |
 |
--------------------------------------------------------- |
|
ExcelSoft Database Professionals |
 |
https://esdbp.createaforum.com |
|
--------------------------------------------------------- |
|
***************************************************** |
|
Return to: Scripts |
|
***************************************************** |
|
#Post#: 11-------------------------------------------------- |
|
Run Diagnostic information on server |
|
By: srinivasma_exceldbp Date: February 27, 2014, 12:24 am |
|
--------------------------------------------------------- |
|
Usage : |
|
exec sp_lib_diagnostics_00 0,0 |
|
exec sp_lib_diagnostics_00 1,1 -- Check Object, Check SPs |
|
Explanation of priority levels: |
|
1 - Critical risk of data loss. Fix this ASAP. |
|
10 - Security risk. |
|
20 - Security risk due to unusual configuration, but requires |
|
more research. |
|
50 - Reliability risk. |
|
60 - Reliability risk due to unusual configuration, but |
|
requires more research. |
|
100 - Performance risk. |
|
110 - Performance risk due to unusual configuration, but |
|
requires more research. |
|
200 - Informational. |
|
#Post#: 148-------------------------------------------------- |
|
Re: Run Diagnostic information on server |
|
By: Yasub_exceldbp Date: April 14, 2015, 6:29 am |
|
--------------------------------------------------------- |
|
Sir, Wonderful script! Thank you! |
|
Can you please point me to the source of this script? |
|
-Yasub |
|
***************************************************** |
