Contents

  1. TIPS
    1. How to Synchronize Two Microsoft SQL Databases
  2. Peformance Tunning
    1. MICROSOFT SQL SERVER PERFORMANCE TUNNING
    2. Determining a drive’s partition alignment offset
    3. SQLIO - Block Size & IOs/sec
    4. NBU MSSQL backup script

TIPS

How to Synchronize Two Microsoft SQL Databases

Peformance Tunning

MICROSOFT SQL SERVER PERFORMANCE TUNNING

Determining a drive’s partition alignment offset

wmic partition get BlockSize, StartingOffset, Name, Index

SQLIO - Block Size & IOs/sec

NBU MSSQL backup script

sql.bht 

SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
SQLHOST "WIN-57NN25E3UC5"
NBSERVER "NBUMASTER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

désert/Microsoft/MSSQL (last edited 2018-10-09 11:24:07 by localhost)