SQL Server newbie
-
As far as Performance is concerened. What are the basic things that need attention in a SQL Server environment? What about Stats?
-
This is a too generic question to be answered here.
Never the less here are some advices:
- Good database design
- good query design
- apropriate HW settingsin term of CPU, RAM, disk, network
Once everyting in place you can test your app by using the profiler, and perfmon
And an another 100.000 daily tasks as a good DBA has to do
Bye
Gabor -
Like nyulq stated, but
Here is something to get you started:
1) depending on the database, you want to separate the data from the log.
2) if possible separate the O/S and SWAP file from either of the above.
3) you will want to use some type of redundancy, stripped, mirrored(hardware) for example we store our data to a SAN and write the log to a Raid 5 set
4) Backup, you WILL want to backup your data. (and store a copy off site) depending your requirement for data loss/recovery.
Hope this help...
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply