MS SQL Server Extended Performance_Tuning.pdf

(4090 KB) Pobierz
Slide 1
WW TSS-02\03
MS SQL Server Extended
Performance & Tuning
social.invensys.com
@InvensysOpsMgmt / #SoftwarerRevolution
/InvensysVideos
/Wonderware
/company/Wonderware
Pierluigi Iodice
Regional Solution Support Engineer,
Wonderware – Invensys Software
Email:
pierluigi.iodice@invensys.com
Javier Aldan
Technical Account Manager
Wonderware – Invensys Software
Email:
javier.aldan@invensys.com
© 2013 Invensys. All Rights Reserved. The names, logos, and taglines identifying the products and services of Invensys are proprietary marks of Invensys or its subsidiaries.
All third party trademarks and service marks are the proprietary marks of their respective owners.
Microsoft SQL Server
•
Wonderware Products has developed with
Microsoft Technologies
•
All Microsoft development languages used are
“Hand and Glove” with SQL Server
What we need to know about MS SQL Server?
A.
B.
C.
SQL Server within Wonderware Database
Database Maintenance, Troubleshooting
Tools & Diagnostic Query
Hands on Custom Project with SQL
Slide 3
Maintenance: The plan
One of the
first tasks
for a new DB is set up a maintenance plan:
•
Understand how to have a backup
•
Define a recovery strategy
•
Truncate Log and Shrink DB
•
Check DB fragmentation
•
Keep the database clean
Slide 4
Maintenance: The backup strategy
You could use the embedded
SQL Server Maintenance:
Maintenance plans create a workflow of the tasks
required to make sure that your database
is optimized,
regularly backed up, and free of inconsistencies.
The Maintenance Plan Wizard also creates core maintenance
plans, but creating plans manually gives you much more
flexibility.
Here all the
task you can
execute!
Slide 5

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin