cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

names of the scrips or task in ms-sql of tasks-100-hcbs-xml

jose_baeza
Participant

Good morning


In the file tasks-100-hcbs-xml
indicates that must be perform the following tasks

Daily:
MsTempdbShrinker
MsLogShrinker

Every weekend:
RemoveOldNdData
DefragIndexes

what are the names of the scrips or task in ms-sql

for the dba that run as indicated by the file

thanks

1 REPLY 1

Radoslaw_Szulgo
Dynatrace Guru
Dynatrace Guru

How to shrink the tempdb database in MS SQL Server?
http://support.microsoft.com/kb/307487

How to Shrink the Transaction Log in MS SQL Server ? 
http://technet.microsoft.com/en-us/library/ms178037(v=sql.105).aspx 

Reorganize and Rebuild Indexes in MS SQL Server ?
http://technet.microsoft.com/en-us/library/ms189858.aspx 

RemoveOldNdData  task - this task is performed internally by CAS and ADS servers. SQL queries are built individually for the current state of the database and cannot be presented as is.

 

 

Senior Product Manager,
Dynatrace Managed expert