Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Approximate hours per month to monitor and maintain the health of MSSQL databases?


Approximate hours per month to monitor and maintain the health of MSSQL databases?

Author
Message
hmbtx
hmbtx
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1427
Based on the description below on average how many hours a month would it take to monitor and maintain the MSSQL Server databases?

Desciption of IT infrastructure.
All Windows Servers and MSSQL Servers are up to date on patches and best practices.
Corporate site with 3 remote sites.
All remote sites have one DC and one MSSQL Server.
The corporate site has one MSSQL Server.
Replication is performed between the remote MSSQL databases and the corporate office MSSQL database.
There is no in-house DBA. All DBA services will have to be outsourced. I am trying to determine what is reasonable in budgeting for time involved for this service.

There is one project written in MS Access using Visual Basic for Applications (VBA) with the backend residing on these databases. Any comments about the pros and cons of the programming languages used will be appreciated.

The question is on average approximately how many hours a month would it take to monitor and maintain the health of the MSSQL Servers database by a MSSQL DBA. The DBA will not have to create any user reporting, queries, etc. Just maintain the existing MSSQL Servers database.

Thank you in advance for any response.



Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24233 Visits: 37978
I'd say it depends on what else you expect from the individual or company providing you with the offsite monitoring services. Monitoring is just one aspect of what is needed. There is also the reporting requirements of the individual or company. What do you expect them to do if alerts fire. What type of response time will the individual or company have to respond to those alerts? What actions are the to take? Do they simply report them to you and you deal with the issue(s) or do they respond and deal with the issues?

Giving you a SWAG, if I were to make a very generic offer, maybe 2 hours per day, and that would actually be 7 days a week not 5 unless you don't care what happens over the weekend.

That doesn't cover responding to issues, nor include any response time to alerts.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
hmbtx
hmbtx
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1427
Lynn:

Thank you for the fast response.

Here are the answers to your questions:

What do you expect them to do if alerts fire?
Resolve the issue.

What type of response time will the individual or company have to respond to those alerts?
There is no defined response time other than what is considered reasonable.

What actions are they to take?
Do they simply report them to you and you deal with the issue(s) or do they respond and deal with the issues?

They will be responsible to fix all issues that come up, apply patches, and keep best practices.

You said maybe 2 hours per day. Could you provide me with some idea as to what they would do during the two hours and why they would have to spend this time each day?

Thanks



Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11034 Visits: 14858
In addition to what Lynn has shared, the answer depends on:

how good the DBA is at automating things
are you willing to put into place and pay for a third-party monitoring package.
Do you expect the DBA to analyze and fix code if deadlocks are occurring?
Do you expect to the DBA to performance tune queries

Frankly, if all you expect is the DBA to keep things up and running, once monitoring is in place and tasks are automated I'd say less than 2 hours a day because for the most part they should be checking a dashboard in the morning that has no issues and then answering SSC questions the rest of the day.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
hmbtx
hmbtx
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1427
Jack

Here are the answers to your questions.

How good is the DBA is at automating things?
Unknown at this point but supposedly very good.

Are you willing to put into place and pay for a third-party monitoring package.
A third party monitoring package is in place for the Windows Network but not specifically for SQL databases.

Do you expect the DBA to analyze and fix code if deadlocks are occurring?
No, the code if from a third party. Just notification that deadlocks are an issue.

Do you expect to the DBA to performance tune queries
No, this would be up to the third party that provides the application software.

What do you mean by "SSC questions"?

Could you provide me with some idea as to what the DBA would do during the day and why they would have to spend this time each day?

I noticed that you are an application developer. Do you have comments on the pros or cons of an application written in Access and Visual Basic for Applications using MSSQL as the backend database?

Thanks



Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11034 Visits: 14858
hmbtx (7/8/2014)

What do you mean by "SSC questions"?


Questions posted on SQLServerCentral


Could you provide me with some idea as to what the DBA would do during the day and why they would have to spend this time each day?


Based on what you have answered they wouldn't have to do a whole lot to keep 4 SQL Servers running. A DBA could be checking current performance against baselines, but that isn't something you'd do constantly. As I said in my first response. The DBA would come in the morning, check the dashboard they'd built to verify jobs ran successfully, backups are good (assuming automated restore processes are in place), and that there are no outstanding alerts. I'd be looking at longest running queries and tuning them, but you said those duties don't apply. They could research ways to speed up backups and reduce space.


I noticed that you are an application developer. Do you have comments on the pros or cons of an application written in Access and Visual Basic for Applications using MSSQL as the backend database?


It's been about 15 years since I worked with Access and VBA as a front end to SQL Server. It works, but I think you can get more flexibility and functionality by using a true development language like C# or VB.NET. Also you don't have to have a license for Access for every user if you use a .NET language. As with any application the way it is architected matters more than the actual platform used. You can write a really poorly performing application on any platform.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
hmbtx
hmbtx
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1427
Jack:

Based on the updated information how many hours per day and how many days per week do you believe the DBA would have to spend in maintaining the databases?

Thanks



Michael L John
Michael L John
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2054 Visits: 7401
It sounds as if you are considering outsourcing your DBA activities, and are trying to determine if their estimate / proposal is a fair one.

A few things to think about:
Almost any outsourcing has a minimum time proposal. It's simply not worth their time to enter into a contract for 2 hours a week. So, if they are proposing 20 hours per server per month, that is probably not out of line.

You should not be comparing the amount of work vs. the time estimate provided. The comparison is how much would a full time employee DBA cost vs. the outsourced DBA.

They should have also provided a "menu" of what they are going to do on an ongoing basis. For example, there may be a 24/7 monitoring department with a 15 minute response time when certain types of events occur. There is some real value to this, and if this what is offered, it is worth a bit more.

Also, you typically do not get a single DBA when you outsource. You get a team of DBA's, each with separate sets of expertise. Again, the comparison needs to be a full time DBA vs. the outsourced DBA. A single DBA cannot be an "expert" on every possible subject that may arise.

Good luck!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
hmbtx
hmbtx
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1427
Michael:

Thank you for your response.

You are correct in that I am trying to determine if their estimate / proposal is a fair one. I should have been clearer in my initial posting.

You said that they should have also provided a "menu" of what they are going to do on an ongoing basis.

Do you have any suggestions as to what should be on their "menu"?

Thanks



Michael L John
Michael L John
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2054 Visits: 7401
The questions are:
What EXACTLY are they going to do in this time?
Do you get an initial assessment?
Do they provide ongoing metrics about your servers?
Do they make recommendations based upon their findings without you asking for help?

If they simply say "we monitor", then you need to ask what they monitor, and what they do when something appears wrong.


You can probably just read it here.
http://www.rdx.com/
These folks are a DBA outsourcing firm.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search