DB Administration

SQL Server Maintenance

I have a SQL Server that houses a small db for about 20 users. I am by no means a DBA. I am currently using Datto to do image level backups every hour. The server has 2 Drives that are mirror running server 2008 and SQL 2008 and 8 GB of Ram. I would like to know what other tasks i should be doing to make sure the DB is healthy. Also i would like to know if there is a way to monitor its performance to make sure its running at its best.
noclavAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kelvin SparksCommented:
Have you ever tested restoring from an image that you took. That's probably as important as taking the image. Is the database setup for full recovery or Simple. I'd recommend that you don't use simple and that you backup (SQL Backup) the transaction log regularly.

You database is small, but I'd look for maintenance plans to rebuild indexes, statistics etc. I'd probably schedule that for a weekly run (I assume you have SQL Server standard for this).

Finally, your versions of Server and SQL are very old - I'd be looking to upgrade.

Kelvin
ste5anSenior DeveloperCommented:
Start with
- Brent Ozar's sp_Blitz
- Ola Hallengren's scripts

But to be honest: Assign a business risk to failures, when those 20 users can no longer work. Hire a SQL Server/DBA consultant for that amount to get at least an full analysis.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
noclavAuthor Commented:
I restored a backup to a VM and was playing with it as I don't want to mess with the production system. I did download Bret's scripts but when I opened the sp_blitz and executed it nothing happens.
ste5anSenior DeveloperCommented:
You need to execute it "twice". Once to install it, then you run EXECUTE sp_Blitz.
noclavAuthor Commented:
k i got it working. checking the results now.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.