Solved

10775: installation and then tuning of the installation

Posted on 2014-11-24
2
91 Views
Last Modified: 2014-11-25
Good day experts:

Is there any URL or document good practices where they are the next steps for the installation and then tuning of the installation and avoid as much as possible the number of tasks and future maintenance when this production, for example tasks such as: the creation and assignment 4 HD physical different for mdf, ldf, backups and tempdb, allocation min and max memory, creating jobs for backups, etc.
0
Comment
Question by:enrique_aeo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
ID: 40464026
My suggestion is to get a good book on the subject. You might like 70-462 Administering Microsoft SQL Server 2012 Databases, which covers the topics in your question.

If you want something smaller, then I would suggest Microsoft® SQL Server® 2008 Administrator's Pocket Consultant.
0
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40464189
Usually those tasks depends on each DBA experience and companies strategy (Virtual machines vs Physical machines; Local storage vs Network storage; use of clusters; 32bits system vs 64bits system, etc...).

For maintenance plans I don't recommend the default provided by Microsoft but this one by Ola Hallegren. You can run a single script and will create jobs for reindexes, backups and integrity checks.

For database files, recommendation is for separate data files from log files. Try to set virtual log files (VLF) in a low number.
Tempdb it's a special database and recommendation it's to be separated from other database files. Brent Ozar has a nice article about this database.

Much more could be said about this question but here you already have something for a startup.

Good luck.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question