Hello,
I am trying to run the best practices analyzer and am getting some time
out errors. Attached is the log. Any help would be greatly appreciated.
Log:
//--
Best Practice log file created at 12/22/2004 10:46:18 AM
Job name: Test
Log file: c:\program files\microsoft sql server best practices
analyzer\log\Test_comp-l-db_0001_comp-L-DB%DBServer_SQLBestPA.log
//--
Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
Getting affinity mask setting... BPAffinityMask.Execute()
Complied ... in BPAffinityMask.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffin ityMask
Preparing rule... Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.BPAllo wUpdate
Getting 'allow update' information... BPAllowUpdate.Execute()
Complied ... in BPAllowUpdate.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.B PAllowUpdate
Preparing rule... Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAutoStat s
Getting AUTO_STAT information for each database... BPAutoStats.Execute()
Complied ... in BPAutoStats.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAut oStats
Preparing rule...
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad
Getting objects information
...Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad .BpCreateDatabaseForLoad.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoa d.BpCreateDatabaseForLoad
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate
Getting objects information
...Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCur sorForUpdate.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCu rsorForUpdate
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es
Getting objects information
...Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursor Usages.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCursorUsages.BpCurso rUsages
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLevel
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLe vel
Preparing rule...
Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
Getting machine name and list of databases ... BpFileCompression.Execute()
Complied ... in BpFileCompression.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDBBacku ps
Getting database names ... BPDBBackups.Execute()
Getting readonly state and backup infor for each database ...
BPDBBackups.Execute()
Partially Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDB Backups
Preparing rule... Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPMsMSDB Backup
master: Database has been backed up in the specified period.
msdb: Database has been backed up in the specified period.
Complied ... in BPMsMSDBBackup.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPM sMSDBBackup
Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
Getting current date ... BPNoLogBackup.Execute()
Getting machine name and server instance ... BPNoLogBackup.Execute()
Getting info from NT Event Log ... BPNoLogBackup.Execute()
Complied ... in BPNoLogBackup.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.BPDbSQ LOptions
Getting databases and SQL option settings... BPDbSQLOptions.Execute()
Partially Complied ... in BPDbSQLOptions.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.B PDbSQLOptions
Preparing rule... Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefaultsR ules
Not Complied ... in BpDefaultsRules.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefa ultsRules
Preparing rule... Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP
Getting objects information
...Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprec atedSP.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepre catedSP
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpDatabaseFilePlacement.BPD BFilePlacement
Getting all DB Names... BPDBFilePlacement.Execute()
Getting file placement information... BPDBFilePlacement.Execute()
Partially Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseFilePlacemen t.BPDBFilePlacement
Preparing rule... Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull
Getting objects information
...Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNu ll.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsN ull
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
Getting machine and instance name... BPNoLogBackup.Execute()
Getting error log path... BPNoLogBackup.Execute()
Getting log size ... BPNoLogBackup.Execute()
Complied ... in BPFailedBackupEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
Preparing rule... Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias
Getting objects information
...Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExp ressionAlias.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpExpressionAlias.BpEx pressionAlias
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
Getting current date ... BPFailedBackupEvent.Execute()
Getting machine name and server instance ... BPFailedBackupEvent.Execute()
Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
Complied ... in BPFailedBackupEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
Preparing rule... Microsoft.SqlBpa.Rules.BPFibers.BPFibers
Getting lightweight pooling setting... BPFibers.Execute()
Complied ... in BPFibers.Execute()
Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BPFibers.BPFibers
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimized
Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
Complied ... in BPFTBackgroundServicesOptimized.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOptimized
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTBlobExtensionType.BPFTB lobExtension
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTBlobExtensionType. BPFTBlobExtension
Preparing rule... Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPFTCata logs
Getting all databases... BPFTCatalogs.Execute()
Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPF TCatalogs
Preparing rule...
Microsoft.SqlBpa.Rules.BpFullTextCatalogPlacement. BPFullTextCatPlacement
Getting all databases... BPFullTextCatPlacement.Execute()
Complied ... in BPDBBackups.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogPlace ment.BPFullTextCatPlacement
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnabled.B PFTChangeTracking
Getting databases... BPFTChangeTracking.Execute()
Complied ... in BPFTChangeTracking.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnab led.BPFTChangeTracking
Preparing rule... Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate
Getting objects information
...Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupli cate.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupl icate
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
Getting machine name ... BPFTMSSearchLocalSystem.Execute()
Complied ... in BPFTMSSearchLocalSystem.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
Preparing rule...
Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
Getting machine name... BPFTPropertyStore.Execute()
Complied ... in BPFTPropertyStore.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
Preparing rule...
Microsoft.SqlBpa.Rules.BpFullTextIndexedTimestampC olumn.BPFTIndexedTimestampColumn
Complied ... in BPFTIndexedTimestampColumn.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFullTextIndexedTimes tampColumn.BPFTIndexedTimestampColumn
Preparing rule...
Microsoft.SqlBpa.Rules.BpIndexDefragmentation.BPIn dexDefrag
Getting database names ... BPIndexDefrag.Execute()
Complied ... in BPIndexDefrag.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpIndexDefragmentation .BPIndexDefrag
Preparing rule... Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType
Getting objects information
...Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpIndexType.BpIndexTyp e
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List
Getting objects information
...Microsoft.SqlBpa.Rules.BpInsertColList.BpInser tColList.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpInsertColList.BpInse rtColList
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpInvalidUserTables.BpInval idUserTables
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpInvalidUserTables.Bp InvalidUserTables
Preparing rule...
Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.BPFixe dLogGrowth
Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.B PFixedLogGrowth
Preparing rule... Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMaxServ erMem
Getting config values... BPMaxServerMem.Execute()
Getting all databases & full-text enabled status ...
BPMaxServerMem.Execute()
Not Complied ... in BPMaxServerMem.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMa xServerMem
Preparing rule... Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er
Getting objects information
...Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAns iOuter.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAn siOuter
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
Not Complied ... in NoPk.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
Preparing rule... Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuil tins.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBui ltins
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Exe cute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Execute ()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es
Getting objects information
...Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSys Tables.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSy sTables
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals
Getting objects information
...Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrd erByOrdinals.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOr derByOrdinals
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BPDBDis kSpace
Checking db size... BPDBDiskSpace.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BP DBDiskSpace
Preparing rule...
Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled.BPPr iorityBoost
Getting 'priority boost' information... BPPriorityBoost.Execute()
Not Complied ... in BPPriorityBoost.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled .BPPriorityBoost
Preparing rule... Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames
Getting objects information
...Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQual ifiedNames.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQua lifiedNames
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPRecInt erval
Getting current recovery interval setting... BPRecInterval.Execute()
Complied ... in BPRecInterval.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPR ecInterval
Preparing rule... Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPReuseBk upFile
Getting readonly state and backup info for each database ...
BPReuseBackupFile.Execute()
Complied ... in BPReuseBackupFile.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPRe useBkupFile
Preparing rule...
Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.BPRecM odelUsage
Getting database names ... BPRecModelUsage.Execute()
Partially Complied ... in BPRecModelUsage.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.B PRecModelUsage
Preparing rule...
Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
Getting current date, machine name, and instance name ...
BPSevereErrorEvent.Execute()
Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
Complied ... in BPSevereErrorEvent.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
Preparing rule... Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
Getting objects information
...Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Exe cute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Execute ()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSize.BP SetWorkingSetSize
Getting config values... BPSetWorkingSetSize.Execute()
Complied ... in BPSetWorkingSetSize.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSi ze.BPSetWorkingSetSize
Preparing rule... Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
Getting objects information
...Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.E xecute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Execu te()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule...
Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
Getting current date, machine name, and instance name ...
BPUnexpectedShutdown.Execute()
Getting startup and shutdown info from NT Event Log ...
BPUnexpectedShutdown.Execute()
Identifying possible undexpected shutdowns ...
BPUnexpectedShutdown.Execute()
Retrieveing possible begin time for unexpected shutdown prior to startup ...
BPUnexpectedShutdown.Execute()
Complied ... in BPUnexpectedShutdown.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
Preparing rule... Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure
Getting objects information
...Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfi gure.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure .Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConf igure
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption
Getting objects information
...Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpti on.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpt ion
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpStar.BpStar
Getting objects information
...Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BpStar.BpStar
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpNullServername.BPNullServ er
Getting @.@.servername... BPNullServer.Execute()
Complied ... in BPNullServer.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpNullServername.BPNul lServer
Preparing rule... Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BPTempD BSize
Complied ... in BPTempDBSize.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BP TempDBSize
Preparing rule... Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables
Getting objects information
...Microsoft.SqlBpa.Rules.BpTempTables.BpTempTabl es.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables.E xecute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTempTables.BpTempTab les
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By
Getting objects information
...Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoO rderBy.Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By.Execute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNo OrderBy
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerNested.BpTrig gerNested
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
Getting objects information
...Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTrig gerNoCount.Execute()
Not Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTri ggerNoCount
Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
Getting objects information
...Microsoft.SqlBpa.Rules.BpTriggerResults.BpTrig gerResults.Execute()
Complied ... in Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpTriggerResults.BpTri ggerResults
Preparing rule...
Microsoft.SqlBpa.Rules.BpUserObjectsInMasterDataba se.BPUserObjInMaster
Getting all user objects in master database ... BPUserObjInMaster.Execute()
Not Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUserObjectsInMasterD atabase.BPUserObjInMaster
Preparing rule... Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPUserOb jNaming
Partially Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPU serObjNaming
Preparing rule...
Microsoft.SqlBpa.Rules.BpVirtualLogFileCount.BPVir tualLogFiles
Partial Complied ... in BPFTBlobExtension.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpVirtualLogFileCount. BPVirtualLogFiles
Preparing rule... Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints
Getting objects information
...Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpWithHints.BpWithHint s
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope
Getting objects information
...Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope .Execute()
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding.
-- End of inner exception stack trace --
Server stack trace:
at Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope.Exe cute()
at Microsoft.BPA.Server.BPProxy.Execute()
at
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase
mb, Object[] args, Object server, Int32 methodPtr, Boolean
fExecuteInContext, Object[]& outArgs)
at
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
msgData, Int32 type)
at Microsoft.BPA.Server.BPProxy.Execute()
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpXactScope.BpXactScop e
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection
bpInputParams, BPASQLServerInfo sqlServer)
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
the application.
at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
Preparing rule... Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchemaChec k
Checking for schema 'sys' ... BPSysSchemaCheck.Execute()
Complied ... in BPSysSchemaCheck.Execute()
Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchem aCheck
I have a similar problem. First time (yesterday) BPA worked fine. Today it
cant work.
I just desistaled and instaled again but it doesnt work.
The log
Microsoft.BPA.Server.JobCoordinatorComponent.JobCo ordinatorException:
Execution log not found in the repository
Server stack trace:
at
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.updateJobStatus(Int32
jobProgress, Status jobStatus, Boolean fExecutionComplete, Boolean
fNoException)
...
Any suggestion?
"jake" <rondican@.hotmail.com> escreveu na mensagem
news:%234np4kR7EHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am trying to run the best practices analyzer and am getting some
time
> out errors. Attached is the log. Any help would be greatly appreciated.
>
>
> Log:
> //--
> Best Practice log file created at 12/22/2004 10:46:18 AM
> Job name: Test
> Log file: c:\program files\microsoft sql server best practices
> analyzer\log\Test_comp-l-db_0001_comp-L-DB%DBServer_SQLBestPA.log
> //--
> Preparing rule... Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffinityMa sk
> Getting affinity mask setting... BPAffinityMask.Execute()
> Complied ... in BPAffinityMask.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAffinityMask.BPAffin ityMask
> Preparing rule...
Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.BPAllo wUpdate
> Getting 'allow update' information... BPAllowUpdate.Execute()
> Complied ... in BPAllowUpdate.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAllowUpdateEnabled.B PAllowUpdate
> Preparing rule... Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAutoStat s
> Getting AUTO_STAT information for each database... BPAutoStats.Execute()
> Complied ... in BPAutoStats.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpAutoStatistics.BPAut oStats
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad
> Getting objects information
>
...Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad .BpCreateDatabaseForLoad.Ex
ecute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at
>
Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoad.BpC reateDatabaseForLoad.Execu
te()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpCreateDatabaseForLoa d.BpCreateDatabaseForLoad
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCurs orForUpdate.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCursorF orUpdate.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCursorForUpdate.BpCu rsorForUpdate
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorU sages.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpCursorUsages.BpCursorUsag es.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCursorUsages.BpCurso rUsages
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLevel
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDbCmptLevel.DbCmptLe vel
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpDbFileCompression.BpFileC ompression
> Getting machine name and list of databases ... BpFileCompression.Execute()
> Complied ... in BpFileCompression.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDbFileCompression.Bp FileCompression
> Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDBBacku ps
> Getting database names ... BPDBBackups.Execute()
> Getting readonly state and backup infor for each database ...
> BPDBBackups.Execute()
> Partially Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseBackups.BPDB Backups
> Preparing rule... Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPMsMSDB Backup
> master: Database has been backed up in the specified period.
> msdb: Database has been backed up in the specified period.
> Complied ... in BPMsMSDBBackup.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpMasterMSDBBackup.BPM sMSDBBackup
> Preparing rule... Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogBkup
> Getting current date ... BPNoLogBackup.Execute()
> Getting machine name and server instance ... BPNoLogBackup.Execute()
> Getting info from NT Event Log ... BPNoLogBackup.Execute()
> Complied ... in BPNoLogBackup.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNoLogBackup.BPNoLogB kup
> Preparing rule...
Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.BPDbSQ LOptions
> Getting databases and SQL option settings... BPDbSQLOptions.Execute()
> Partially Complied ... in BPDbSQLOptions.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseSQLOptions.B PDbSQLOptions
> Preparing rule... Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefaultsR ules
> Not Complied ... in BpDefaultsRules.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDefaultsRules.BpDefa ultsRules
> Preparing rule... Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepreca tedSP.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDeprecated SP.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BPDeprecatedSP.BPDepre catedSP
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpDatabaseFilePlacement.BPD BFilePlacement
> Getting all DB Names... BPDBFilePlacement.Execute()
> Getting file placement information... BPDBFilePlacement.Execute()
> Partially Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseFilePlacemen t.BPDBFilePlacement
> Preparing rule... Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNul l.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsNull.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpEqualsNull.BpEqualsN ull
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycleErrL og
> Getting machine and instance name... BPNoLogBackup.Execute()
> Getting error log path... BPNoLogBackup.Execute()
> Getting log size ... BPNoLogBackup.Execute()
> Complied ... in BPFailedBackupEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCycleErrorLog.BPCycl eErrLog
> Preparing rule...
Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpr essionAlias.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpExpressionAlias.BpExpress ionAlias.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpExpressionAlias.BpEx pressionAlias
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFailedBackupEvents.BPFail edBackupEvt
> Getting current date ... BPFailedBackupEvent.Execute()
> Getting machine name and server instance ... BPFailedBackupEvent.Execute()
> Getting info from NT Event Log ... BPFailedBackupEvent.Execute()
> Complied ... in BPFailedBackupEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFailedBackupEvents.B PFailedBackupEvt
> Preparing rule... Microsoft.SqlBpa.Rules.BPFibers.BPFibers
> Getting lightweight pooling setting... BPFibers.Execute()
> Complied ... in BPFibers.Execute()
> Cleaning up resources used by
rule:Microsoft.SqlBpa.Rules.BPFibers.BPFibers
> Preparing rule...
>
Microsoft.SqlBpa.Rules.BpFTBackgroundServicesOptim ized.BPFTBgServicesOptimiz
ed
> Getting machine name ... BPFTBackgroundServicesOptimized.Execute()
> Complied ... in BPFTBackgroundServicesOptimized.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFTBackgroundServices Optimized.BPFTBgServicesOp
timized
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTBlobExtensionType.BPFTB lobExtension
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTBlobExtensionType. BPFTBlobExtension
> Preparing rule... Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPFTCata logs
> Getting all databases... BPFTCatalogs.Execute()
> Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogs.BPF TCatalogs
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFullTextCatalogPlacement. BPFullTextCatPlacement
> Getting all databases... BPFullTextCatPlacement.Execute()
> Complied ... in BPDBBackups.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFullTextCatalogPlace ment.BPFullTextCatPlacemen
t
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnabled.B PFTChangeTracking
> Getting databases... BPFTChangeTracking.Execute()
> Complied ... in BPFTChangeTracking.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTChangeTrackingEnab led.BPFTChangeTracking
> Preparing rule... Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplic ate.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDuplicate .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTDuplicate.BpFTDupl icate
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSystem.BPM SSearchLocalSystem
> Getting machine name ... BPFTMSSearchLocalSystem.Execute()
> Complied ... in BPFTMSSearchLocalSystem.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTMSSearchLocalSyste m.BPMSSearchLocalSystem
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize.BPFTP ropertyStore
> Getting machine name... BPFTPropertyStore.Execute()
> Complied ... in BPFTPropertyStore.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFTPropertyStoreSize. BPFTPropertyStore
> Preparing rule...
>
Microsoft.SqlBpa.Rules.BpFullTextIndexedTimestampC olumn.BPFTIndexedTimestamp
Column
> Complied ... in BPFTIndexedTimestampColumn.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpFullTextIndexedTimes tampColumn.BPFTIndexedTime
stampColumn
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpIndexDefragmentation.BPIn dexDefrag
> Getting database names ... BPIndexDefrag.Execute()
> Complied ... in BPIndexDefrag.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpIndexDefragmentation .BPIndexDefrag
> Preparing rule... Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpIndexType.BpIndexType.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpIndexType.BpIndexTyp e
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpInsertColList.BpInsert ColList.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpInsertColList.BpInsertCol List.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpInsertColList.BpInse rtColList
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpInvalidUserTables.BpInval idUserTables
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpInvalidUserTables.Bp InvalidUserTables
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.BPFixe dLogGrowth
> Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpFixedLogFileGrowth.B PFixedLogGrowth
> Preparing rule... Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMaxServ erMem
> Getting config values... BPMaxServerMem.Execute()
> Getting all databases & full-text enabled status ...
> BPMaxServerMem.Execute()
> Not Complied ... in BPMaxServerMem.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpMaxServerMemory.BPMa xServerMem
> Preparing rule... Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsi Outer.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAnsiOut er.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNonAnsiOuter.BpNonAn siOuter
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
> Not Complied ... in NoPk.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNoPrimaryKey.NoPk
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuilt ins.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBuiltins .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldBuiltins.BpOldBui ltins
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Exec ute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc.Execute ()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldDbcc.BpOldDbcc
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysT ables.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSysTabl es.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOldSysTables.BpOldSy sTables
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrde rByOrdinals.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOrderBy Ordinals.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpOrderByOrdinals.BpOr derByOrdinals
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BPDBDis kSpace
> Checking db size... BPDBDiskSpace.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpDatabaseDiskSpace.BP DBDiskSpace
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled.BPPr iorityBoost
> Getting 'priority boost' information... BPPriorityBoost.Execute()
> Not Complied ... in BPPriorityBoost.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpPriorityBoostEnabled .BPPriorityBoost
> Preparing rule... Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQuali fiedNames.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQualifie dNames.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpQualifiedNames.BpQua lifiedNames
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPRecInt erval
> Getting current recovery interval setting... BPRecInterval.Execute()
> Complied ... in BPRecInterval.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpRecoveryInterval.BPR ecInterval
> Preparing rule... Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPReuseBk upFile
> Getting readonly state and backup info for each database ...
> BPReuseBackupFile.Execute()
> Complied ... in BPReuseBackupFile.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpReuseBackupFile.BPRe useBkupFile
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.BPRecM odelUsage
> Getting database names ... BPRecModelUsage.Execute()
> Partially Complied ... in BPRecModelUsage.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpRecoveryModelUsage.B PRecModelUsage
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BPSever eErrorEvt
> Getting current date, machine name, and instance name ...
> BPSevereErrorEvent.Execute()
> Getting info from NT Event Log ... BPSevereErrorEvent.Execute()
> Complied ... in BPSevereErrorEvent.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSevereErrorEvents.BP SevereErrorEvt
> Preparing rule... Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Exec ute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser.Execute ()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSetUser.BpSetUser
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSize.BP SetWorkingSetSize
> Getting config values... BPSetWorkingSetSize.Execute()
> Complied ... in BPSetWorkingSetSize.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpCheckSetWorkingSetSi ze.BPSetWorkingSetSize
> Preparing rule... Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Ex ecute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet.Execu te()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSevenSet.BpSevenSet
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns.BPUne xpectedShutdwn
> Getting current date, machine name, and instance name ...
> BPUnexpectedShutdown.Execute()
> Getting startup and shutdown info from NT Event Log ...
> BPUnexpectedShutdown.Execute()
> Identifying possible undexpected shutdowns ...
> BPUnexpectedShutdown.Execute()
> Retrieveing possible begin time for unexpected shutdown prior to startup
...
> BPUnexpectedShutdown.Execute()
> Complied ... in BPUnexpectedShutdown.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpUnexpectedShutdowns. BPUnexpectedShutdwn
> Preparing rule... Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfig ure.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConfigure .Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSpConfigure.BpSpConf igure
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOptio n.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOption.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSpDbOption.BpSpDbOpt ion
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpStar.BpStar
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpStar.BpStar.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by rule:Microsoft.SqlBpa.Rules.BpStar.BpStar
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpNullServername.BPNullServ er
> Getting @.@.servername... BPNullServer.Execute()
> Complied ... in BPNullServer.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpNullServername.BPNul lServer
> Preparing rule... Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BPTempD BSize
> Complied ... in BPTempDBSize.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTempDBCurrentSize.BP TempDBSize
> Preparing rule... Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTempTables.BpTempTable s.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpTempTables.BpTempTables.E xecute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTempTables.BpTempTab les
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOr derBy.Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNoOrder By.Execute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTopNoOrderBy.BpTopNo OrderBy
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
> Complied ... in Microsoft.SqlBpa.Rules.BpTriggerNested.BpTriggerNe sted
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerNested.BpTrig gerNested
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTrigg erNoCount.Execute()
> Not Complied ... in
Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTriggerN oCount
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerNoCount.BpTri ggerNoCount
> Preparing rule... Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpTriggerResults.BpTrigg erResults.Execute()
> Complied ... in Microsoft.SqlBpa.Rules.BpTriggerResults.BpTriggerR esults
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpTriggerResults.BpTri ggerResults
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpUserObjectsInMasterDataba se.BPUserObjInMaster
> Getting all user objects in master database ...
BPUserObjInMaster.Execute()
> Not Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
>
rule:Microsoft.SqlBpa.Rules.BpUserObjectsInMasterD atabase.BPUserObjInMaster
> Preparing rule...
Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPUserOb jNaming
> Partially Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpUserObjectNaming.BPU serObjNaming
> Preparing rule...
> Microsoft.SqlBpa.Rules.BpVirtualLogFileCount.BPVir tualLogFiles
> Partial Complied ... in BPFTBlobExtension.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpVirtualLogFileCount. BPVirtualLogFiles
> Preparing rule... Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpWithHints.BpWithHints.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpWithHints.BpWithHint s
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope
> Getting objects information
> ...Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope. Execute()
> System.Data.SqlClient.SqlException: Timeout expired. The timeout period
> elapsed prior to completion of the operation or the server is not
> responding.
> Microsoft.BPA.BestPractice.BPException: Timeout expired. The timeout
period
> elapsed prior to completion of the operation or the server is not
> responding. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server
is
> not responding.
> -- End of inner exception stack trace --
> Server stack trace:
> at Microsoft.SqlBpa.Rules.BpXactScope.BpXactScope.Exe cute()
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(Met
hodBase
> mb, Object[] args, Object server, Int32 methodPtr, Boolean
> fExecuteInContext, Object[]& outArgs)
> at
>
System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessa
ge
> msg, Int32 methodPtr, Boolean fExecuteInContext)
> Exception rethrown at [0]:
> at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
> reqMsg, IMessage retMsg)
> at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData&
> msgData, Int32 type)
> at Microsoft.BPA.Server.BPProxy.Execute()
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpXactScope.BpXactScop e
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Timeout
> expired. The timeout period elapsed prior to completion of the operation
or
> the server is not responding.
> at
>
Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueC
ollection
> bpInputParams, BPASQLServerInfo sqlServer)
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in
> the application.
> at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
> Preparing rule... Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchemaChec k
> Checking for schema 'sys' ... BPSysSchemaCheck.Execute()
> Complied ... in BPSysSchemaCheck.Execute()
> Cleaning up resources used by
> rule:Microsoft.SqlBpa.Rules.BpSysSchema.BPSysSchem aCheck
>
>
|||Hi, Jake
I have the same problem...
Do you found a solution ?
Thanks
Regards
Thierry
Message posted via http://www.sqlmonster.com
|||Hi Thierry,
Are you seeing any timeouts in the log?. Could you explain the sequence of
steps you did to hit this error?.
It would be great if you could post the full log
Thanks
Sethu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Thierry via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:31f24cc7f1a94cb3a1f486af99bfeb9e@.SQLMonster.c om...
> Hi, Jake
> I have the same problem...
> Do you found a solution ?
> Thanks
> Regards
> Thierry
> --
> Message posted via http://www.sqlmonster.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment