July 26, 2008 at 1:51 am
hI ,
I WANT TO KNOW ABOUT DBA RESPONSIBILITIES AND iNEED TO HELP SOLVE TO BELOW QUESTIONS.
CHECK JOB FAILURES?
CHECK DISKSPACE?
HOW TO CHECK THE FILEGORWTH ?
HOW TO TRUNCATE TRANSACTIONAL LOG FILE?
CHECK THE CPU UTILIZATION?
PLEASE WRITE A SYNTAX FOR EACH QUESTION ASAP
July 26, 2008 at 2:17 am
sqldba.hl (7/26/2008)
hI ,I WANT TO KNOW ABOUT DBA RESPONSIBILITIES AND iNEED TO HELP SOLVE TO BELOW QUESTIONS.
CHECK JOB FAILURES? -- agent history - add notifications in to email you.
CHECK DISKSPACE? -- lookup the xp_fixeddrive SP - there was a script on here yest
HOW TO CHECK THE FILEGORWTH ? --You can only do this (i think) by keeping a table with the file sizes in and periodically checking to see if its grown (sp_spaceused)
HOW TO TRUNCATE TRANSACTIONAL LOG FILE? --This is a DBA job is required, but shouldnt be done. search the forum for truncating log files
CHECK THE CPU UTILIZATION? -- Performance monitor is your best (free) choice. If you want it running all the time add an alert and base it on the CPU figure rising above 75% (or whatever you deem to be high)
PLEASE WRITE A SYNTAX FOR EACH QUESTION ASAP
July 26, 2008 at 9:49 am
Please don't use all caps. It's the online equivalent of shouting at someone.
sqldba.hl (7/26/2008)
hI ,PLEASE WRITE A SYNTAX FOR EACH QUESTION ASAP
Why? Is this for a test or interview?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 26, 2008 at 10:06 am
This sounds like a test or interview questions, as Gail mentioned, and we don't solve those for you.
Please put in questions that you have, but show some effort to have solved them yourself or where your confusion is.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply