Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2012-10-29 : 17:19:37
|
I have general feeling as a DATABASE ADMINISTRATOR,on a normal circumstances of DBA work if everything working fine and doing good according to the rules of the organisation,also there require NO involvement apart from CHECKING IN GENERAL then what would be other matters that need to take care. APART FROM THESE (Running absolutely fine): such as procuring backups; maintenance plans; database availability 24 /7; checking the out-of-business hours jobs that has planned well; tables; indexes; Reindexes if any; looking for fragmentation checkups;any new version / patch work for the SQL environment; Logins structure like checking the obsolete SPID's, if necessary releasing them; Alerts; Notifications; Operators; SQL Agent Jobs according to their schedule running;Checking Errorlogs in detail checks no un-toward incidents being reported;Ok Everything is fine and what else I need to post this to the Peers and experts of this ever supporting office?Still what, where and how as a DBA should still 'encroach' into those 'AREAS' which haven't touched yet, can anyone still take time to ELOBORATE into doing .... Perhaps this would be useful for all those new and developing into full fledged DBA's and know the Duties to excel in forseeing the oncoming events.Your Help is much to appreciate and thankful. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-29 : 17:29:43
|
| Performance monitoring and analysis. A DBA should have some kind of monitoring system in place, either an off-the-shelf product or a home-grown system/method. Monitoring should collect metrics regularly, not just send alerts when something is going wrong. Analysis should be regular and steps taken to improve performance, even if existing performance is acceptable.A DBA should also always be learning, studying, and applying their knowledge to their job. They should also be teaching their coworkers this knowledge whenever possible. |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2012-10-29 : 17:39:28
|
| To Deal with Performance Monitoring.... is wide range of spects as in Production environment and need to look into behaviour of Indexes; and CPU, I / O levels when the results obtained how to decipher (use basic T-SQL to gather them) and so on....Can you eloborate in detail to NEGOTIATE with them and still making the data efficient. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-29 : 18:01:51
|
| I don't understand your question about negotiating.Performance monitoring isn't just query and index tuning. You need to gather performance counters, collect SQL wait stats, and record them to generate performance baselines and trends. From those baselines you can perform analysis to determine if performance is improving or not, and identify if certain actions caused impact (e.g. moving files to a new drive, changing backup schedule, adding more RAM, etc.) If you're unsure what to monitor I'd recommend a third party tool like SQL Sentry. It will manage all the collection and analysis and provide reports on your system and where to focus tuning efforts, or identify bottlenecks that may need hardware upgrading. |
|
|
|
|
|
|
|
|
Everything is Fine !!!!