BTI Server
Project Name : BTI
Database Name : MaxManagecall_BTI_Live (172.30.30.4)
Full DB Backup Job Schedule Time : Occurs every day at 11:10:00 PM.
Trans DB Backup Job Schedule Time : Occurs every 15 min interval.
Database Name : MaxInfoxchange_BTI_Live (172.30.30.9)
Full DB Backup Job Schedule Time : Occurs every day at 12:05:00 AM.
Trans DB Backup Job Schedule Time : Occurs every 30 min interval.
Temp DB
Data / log size restriction & resolution
Adding data / log file
Disk space management
Database Backup Retention Periods
Full backup / Transaction backup
synchronization of link server database
Jobname Days\Months
Archive_BulkDownTickets 3 months
Archive_BULKTICKETCLOSURE 3 months
Archive_DeviceHealthHistory 3 months
Archive_RowMessage 07 Days
Archive_SqlJobDetails 03 Months
Archive_TBL_ETADetails 03 Months
Archive_tblFCR 03 Months
Archive_tblTicketIds 03 Months
Archive_tblTicketLog 03 Months
Archive_TerminalCashStatusFeed 03 Months
Archive_TicketComments 03 Months
Archive_TicketsAdditionalData 90 Day
Archive_TicketsDownTime 3 months
Archive_TicketsDownTimeDetails 3 months
Archive_ticketTable 3 months
ArchiveMessageDetails 45 Days
ArchiveMessageDetailsQUEUE 45 Days
ArchiveVendorIntegrationLog 02 Months
Delete_EmailCashFileData_MaxManagecall 05 Days
Delete_tblTicketIds_MaxManagecall 3 months
MOF
Database Name : 1) MaxManageCall_D01 --(172.30.30.6)
2) MaximusForeCashD29 (172.30.30.6)
Full DB Backup Job Schedule Time : Occurs every day at 11:35:00 PM.
Trans DB Backup Job Schedule Time : Occurs every 30 min interval.
Database Name : 1) InfoXchange (172.30.30.5)
3) InfoXchange (172.30.30.5)
4) MaxForeCash (172.30.30.5)
5) MaxCRManagement & EMSPunching (172.30.30.5)
Full DB Backup Job Schedule Time : Occurs every day at 12:30:00 AM.
Trans DB Backup Job Schedule Time : Occurs every 30 min interval.
Disk space management
Database Backup Retention Periods
Full backup / Transaction backup
synchronization of link server database
Server - 172.30.30.6
Jobname Days\Months
Archive TicketComments 12 Months
Archive_DeviceHealthHistory 12 Months
Archive_SBIFeedsArcTable 08Days
Archive_tblTicketLog 12 Months
Archive_Tickets 24 Months
Archive_TicketsDownTimeDetails 12 Months
ArchiveMessageDetails 30 Days
ArchiveRawFeed 25 Days
ArchiveTerminalCashStatusFeed 180 Days
Server - 172.30.30.5
Jobname Days\Months
Archival Database_EJDataTransactions 06 Month
Archive_TRANSACTIONLOG 04 Months
ArchiveCashFeedHistory_Table 06 Month
DeleteUnProcessedEJ 10 Days
ArchiveCASHFEEDALERT_Daily_SavedDetails_FC 06 Month
ArchiveCasshFeedDispenseDetails_FC 06 Month
ArchiveCBRData_FC 06 Month
ArchiveCBRFileImportDetails_FC] 06 Month
ArchiveCLLDetails_FC 06 Month
ArchiveDailyLoadingDeatils_FC 06 Month
ArchiveIndentDetails_FC 06 Month
ArchiveIndentEnquiry_FC 06 Month
ArchiveIndents_FC 06 Month
ArchiveTbl_AutoIndentStatus_FC 06 Month
ArchiveTbl_CashFeedLoadingStatus_FC 06 Month
Archivetbl_FileDetails_FC 06 Month
ArchiveTbl_TentativeConfig_FC 06 Month
Monitoring SQL Agent Jobs, DB jobs, long running queries with blocking
SQL Server Agent Jobs
Monitoring with “SQL Server Agent” tools showing Jobs history and ruining interval also.
DB Jobs -- Creating with maintenance plan for DB Jobs like.
1) DB backup
2) Differential backup
3) Transitional backups
4) History cleanup task
5) Indexes rebuild task
6) Indexes re- organization task
7) Indexes statics update task
How to check Long running queries and blocking
1) Check with activity monitor
2) SP_WHO2 Active
3) Bulk id
4) Spid (Session ID)
