- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DBA's duty?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2005 01:57 AM
тАО08-01-2005 01:57 AM
Re: DBA's duty?
You could also describe the sort of problems and fixes found during the month so that mistakes are not repeated by others and so that techniques that work can be shared.
One of the most useful approaches that I have learned over the years is to force development and test to be done on a slower/resource limited machine but with realistic data volumes. The developers will hate it initially because "my compiles take forever". That's bogus because at most compiles/links comprise 1% of the development time. The idea is that when the code is efficient enough to run well on a dog, it will run well on a fast production box. This helps to avoid the kinds of scaling problems that often occur when code is moved from a development to production environment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2005 04:04 AM
тАО08-01-2005 04:04 AM
Re: DBA's duty?
As far as getting your database statistics. If you have like hardware in your test and dev environemnt. Take say a BCV copy or a LVM mirror of production, and place that developement into Dev. See how it performs, prevent surprise :). There are many storage options these days to take these snapshots for testing.
Also if you have Vpars you could up and down your resoursces on the fly to see your critical thresholds in performance vs hardware resources :).
Just some ideas, for testing the impact to your database.
In terms of the performance cookbook it will be helpful for you to understand how your new apps/changs may impact kernel parameters that may have new requirements that are causing speed issues.
With Databases Disk layout is very important. Make sure you are striping and that you have layed your disks out evenly across the back of your san/controllers, and backend fibers. Just because you have powerpath/securepath doesnt mean a bad data layout cant bite you. It is possible that your new app is just exploiting an underlying issue such as this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2005 12:58 PM
тАО08-01-2005 12:58 PM
Re: DBA's duty?
Thanks
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2005 01:50 PM
тАО08-01-2005 01:50 PM
Re: DBA's duty?
Only the DBA or SA have the privilege to upload programs from a staging area to the production.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2005 09:37 PM
тАО08-01-2005 09:37 PM
SolutionDBA's duty is whatever is the job profile within your company. I mean the range of tasks and responsibility differ from one company to another. Sometimes you look after the space requirement and performance of a database / application, sometimes you can be involved in the development cycle.
I suppose the answer to your question is "process" or procedure. Each time the AP team deliver a new program, the "process" is there to ensure that everything has been done to guarantee performance are not altered. I don't mean this is perfect but this does help. Keep the communication line open !
Also, you should have a performance baseline for your different databases / applications. Therefore when a new program is delivered you can compare with previous stats. Obviously, this is better if you can this process in an uat environment.
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2005 04:04 PM
тАО08-02-2005 04:04 PM
Re: DBA's duty?
also run regular statspack snapshots at peak periods (15mins snaps)
You can also send these reports to experienced AP Team members for review (especially the parts:
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executes)
hope this helps too!
regards
yogeeraj
- « Previous
-
- 1
- 2
- Next »