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


DBA Support


DBA Support

Author
Message
Miles Neale
Miles Neale
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2750 Visits: 1694
I also for security purposes cannot supply the metrics. But we have two DBA's who manage the various machines and databases. We have at least three environments on common virtual servers those being production, dev/test, and rip_and-tear. We also have a few SQL installations on workstations for personal data analysis, cube and pivot table development, and high risk manipulation and programming. We have sql 2000 through SQL 2012 all running in one capacity or another. The database size is from really small to almost large. And we manage metadata, tabular, spatial, and document and image data. We also manage the SQL in the back-end of SharePoint.

Management tools include a collection of scripts, alerts, and monitors to check the health and well being of the servers and the data. This collection is being reviewed, researched, and expanded as time allows and need demands.

M.

Not all gray hairs are Dinosaurs!
SQLBill
SQLBill
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3690 Visits: 1040
We don't organize by number of databases...we each have 10-15 servers to be responsible for. I too was an accidental SQL Server DBA at my first job. I was actually trained as an Oracle Programmer, but that had to change quickly. Eventually I moved on. But how I wish I could go back to that first job knowing what I know now. The things I struggled with setting up and figuring out how to do....could have done it so much easier.

-SQLBill



amkarkha
amkarkha
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 21
Small business. I am a developer. 'Captive' DBA, I am the only option we have.
One SQL server 2008R2, Two databases (one production on test). 40GB data. Hosted in Cloud IaaS.
I have automated backup (daily full and log), index rebuilding. log shipping using Sql server maintenance plans.
I have not set the email notifications. I audit the server about once every two weeks.
What concerns/scares me is what I may be missing or am unaware of.

I am curious to know about - 'a day in the life of a DBA that manages thousands of databases (like some of the responders have mentioned)'.
jhennes2
jhennes2
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 3
I manager over 650 databases across 30+ instances. 2005, 2008, 2008R2. Several terabytes of data to 10-20 GB to 300 MB for the sizes of databases. Typical day - answering questions, migrating applications to 2008 from 2005, automation and reviewing SCOMS alerts, and restoring production to test environment for process testing.
jmadsen 98862
jmadsen 98862
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 679
12 server instances
6600+ databases

Various production, test, BI, reporting servers/DBs.

Prod DBs range from 2MB to 15GB
BI/reporting DBs from very small to 500GB

2 "DBAs"; I'm the only official DBA, my boss does much of the work also.
I do not do any server maintenance, upgrades etc., a senior sysadmin does that.

When I started everything was already very automated.
My typical days are monitoring servers, adhoc requests, "data troubleshooting/updates", and BI/ETL projects.
BI has been getting more and more part of my workload.
pdanes
pdanes
Mr or Mrs. 500
Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)Mr or Mrs. 500 (514 reputation)

Group: General Forum Members
Points: 514 Visits: 1354
Developer, originally in Fortran, Cobol and RPG (I go back a few years), eventually migrated to Office/VBA, recently to Access/Sql Server. Accidental and unintentional DBA, along with still being a developer, hardware maintainer, operator and generally chief cook and bottle washer. I am the -only- IT person in the shop, so I do everything. There are two servers, one running a web site, the other our internal databases. One instance of SQL Server Express 2008 R2 on each, one database on the web server, seven on the internal one. 150MB for largest database, others much smaller, but growing. Especially with all the Access/SQ Server development, far too much for me to handle properly, but it beats being bored.
Simon D Richards
Simon D Richards
SSC Veteran
SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)

Group: General Forum Members
Points: 210 Visits: 639
Catching up on emails and I saw this editorial. My last post we had 3 servers and about 15 databases, and about a year ago I took a new job. At the interview I was told there were 20 instances with 50 databases. I am now managing 88 instances and over 1200 databases. It has been challenging, but a lot of fun as well, it has certainly accelerated my learning and I have learnt power shell to manage my time, otherwise I would be overwhelmed.

Now for some consolidation...
rob-846413
rob-846413
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 98
Started off as an accidental DBA and now turned it out to be a career - absolutely love it!

I look after approx 25 x SQL Servers
richardmgreen1
richardmgreen1
SSC Eights!
SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)SSC Eights! (808 reputation)

Group: General Forum Members
Points: 808 Visits: 912
Apparently I'm the in-house DBA for 5 servers (out of a total of 88 instances). Biggest database is around 300GB (so far) and growing.

There isn't an "official" DBA in this place and, like someone else already posted, my day-job is a developer but it's amazing how priorities change when something goes bang.

I'm trying to get them to hire a DBA (i.e. give me a new job) as 99% of the staff that currently "manage" the servers haven't got a clue.
tutupouet
tutupouet
Valued Member
Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)

Group: General Forum Members
Points: 74 Visits: 278
5 SQL DBAs for
~30 production instances from 2008 to 2014 (mainly 2012)
~25 pre-prod
~10 QA
~45 test/sandbox/dev
~1800 DB up to 2TB (total ~70Tb)
Windows clustered instances, Availability Groups, Transactional replication, log shipping, mirroring, SSIS, SSRS, SSAS, SAP, Sharepoint, Biztalk ...
we mainly use custom alerting/monitoring based on SQLAgent, SQL alerts, SQL policies, SSRS ...

we want to buy a tool to centralise/standardize monitoring/alerting/analysing for all our servers but for the moment we dont find the one suits to us BigGrin
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