SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA Morning Check List


DBA Morning Check List

Author
Message
Bill Richards-377350
Bill Richards-377350
SSC-Enthusiastic
SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)SSC-Enthusiastic (132 reputation)

Group: General Forum Members
Points: 132 Visits: 395
Comments posted to this topic are about the item DBA Morning Check List
Ritesh Mehta
Ritesh Mehta
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 39
Dear Richard,
Nice Article. Smile

If you can put more lines for Database Optimization,
would be more greatful for me.

My Company's present SQL database scenarios is as below.

Database Name: Buzz_Data
Database Size: 12.3 GB
Data Files: 1 (Primary)
Transaction Log File: 1
Database Tables: 500+

At Present my user's are facing problem to retrive data in time inspite of having Server's config like Intel XEON (IBM) , 2 GB Ram, 80 GB HDD.

Can you advice me to help my users.

Thanks, in anticipation.

Regards,
Ritesh Mehta
DBA
Gujarat (India)
debmed
debmed
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 166
Great article. I currently have a checklist that I now live by.
Especially when one thing goes wrong that requires immediate attention, a checklist allows to easily pick up where you left off on your daily routines. especially at 5-6 am, coffee alone isn't always enough...

I also group my daily checklist with weekly and monthly processes. I Identify and track errors now by a high-level type to help identify problems like recurring issues, server issues and network issues unrelated to the databases but affect them.

deb-salem, ma
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6466 Visits: 1439
Excellent article. You can combined with the Microsoft SQL Server 2000 operations guide (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx )




My blog

SuperDBA-207096
SuperDBA-207096
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2963 Visits: 711
Excellent Article!

The operations guides and checklists Microsoft offers are pretty helpful, especially the one for setting up clustering.
Key DBA
Key DBA
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1681 Visits: 655
Bill,

Thanks for taking the time to write this article. I have implemented a similar process in my environment. To collect the majority of my data, I use a modified version of David Bird's SQL Overview SSIS Package.


SQL Overview Part 1
By David Bird, 2008/01/07
http://www.sqlservercentral.com/articles/Integration+Services/61621/

SQL Overview SSIS Package II - Retrieving SQL Error Log
By David Bird, 2008/01/14
http://www.sqlservercentral.com/articles/Integration+Services/61714/

SQL Overview SSIS Package III - Full Package
By David Bird, 2008/01/22
http://www.sqlservercentral.com/articles/Integration+Services/61774/


Using David's articles and SSIS code, I have customized it for the uniqueness of the systems which I am responsible for. Your idea of printing everything out and storing in a binder with signatures, will be a a topic for discussion with my next planning meeting with my boss. I look forward to your future SSC postings.

Regards,

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
rubes
rubes
Old Hand
Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)

Group: General Forum Members
Points: 398 Visits: 398
Nice article. I would just like to point out that for those of us that have numerous servers, automation of the checklist is critical. If you're dealing with only one server, manually checking these things does not take a lot of time. But imagine checking job failures or drive space on 50 sql servers. We get paid too much to perform these menial tasks by hand. There are many 3rd party tools out there that do this for us. It's also pretty easy to write your own scripts and sql jobs... many starter scripts could probably be found on this forum.

One benefit of automating your checklist is time. The other benefit is proactive in nature. If a drive is out of space because tempdb exploded in size over night, it's better to get notified via email at 4 am. Sure, the cell phone disturbs your precious sleep, but you now have 4 hours to fix the situation before business opens at 8 am and people start screaming.

Also, if there are numerous DBAs on your team, automating these checks helps greatly with standardization.

Regards,
Rubes
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6466 Visits: 1439
Damon Wilson (4/14/2008)
Bill,

Thanks for taking the time to write this article. I have implemented a similar process in my environment. To collect the majority of my data, I use a modified version of David Bird's SQL Overview SSIS Package.


SQL Overview Part 1
By David Bird, 2008/01/07
http://www.sqlservercentral.com/articles/Integration+Services/61621/

SQL Overview SSIS Package II - Retrieving SQL Error Log
By David Bird, 2008/01/14
http://www.sqlservercentral.com/articles/Integration+Services/61714/

SQL Overview SSIS Package III - Full Package
By David Bird, 2008/01/22
http://www.sqlservercentral.com/articles/Integration+Services/61774/


Using David's articles and SSIS code, I have customized it for the uniqueness of the systems which I am responsible for. Your idea of printing everything out and storing in a binder with signatures, will be a a topic for discussion with my next planning meeting with my boss. I look forward to your future SSC postings.

Regards,



I also use the SQL Overview package from David. It is a great help to minitor the SQL infrastructure.




My blog

Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6466 Visits: 1439
rubes (4/14/2008)
Nice article. I would just like to point out that for those of us that have numerous servers, automation of the checklist is critical. If you're dealing with only one server, manually checking these things does not take a lot of time. But imagine checking job failures or drive space on 50 sql servers. We get paid too much to perform these menial tasks by hand. There are many 3rd party tools out there that do this for us. It's also pretty easy to write your own scripts and sql jobs... many starter scripts could probably be found on this forum.


Could you please name some of the third party tools.

Thanks in advance.




My blog

Jerry Hung
Jerry Hung
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3420 Visits: 1208
Useful discussion

It is a bit harder when the SQL Servers are hosted off-site to collect "stuff"
and that I am not yet on the "critical error" production email list Sad

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
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