For any SQL Server DBA who has been in the game longer than the advent of SQL Server 2005, there was one standard place to turn when you wanted to tune your database. You would turn to the profiler! If you had some experience with this, and had been burned by getting too small of a sample of throughput, you knew that you needed to run it for enough time to get a true sample of what your server was doing. You needed to get a true sample of both reads and writes so that you wouldn’t be skewed one way or the other when deciding how many indexes would be ideal.
Many Database Administrators are aghast when they discover that SQL Server 2005 and above have a default trace that runs 24 hours a day, 7 days a week. Most of us are taught early on in our careers that extended tracing is something that should only occur on rare occasions. Before you rush out and disable the default trace across all of your SQL Servers, let’s take a moment to find out what it’s actually capturing for us.
Here is a way to create an SSIS that audits the transfer of data each step of the way. The main transformations used for this are:
Recently I ran into an issue where I had a SQL Server instance that needed to have a database restored on it. A pretty simple task, right? Well, it turns out that I did not have rights on the system to do the restore. My client did not have a system administrator password and did not have a user which we could use to grant us the necessary access. But, I did have local system administrator privileges on the server. As long as we have local admin rights on the server we can get the necessary privileges from SQL Server.
You got the job because you’re a quick learner, have the ability to understand complex systems, and most importantly, you can troubleshoot. However you became an Oracle Apps DBA, you’re one now, so the fun starts. I started this blog to assist young Oracle Apps DBA professionals who might need a little more detail in their solutions and good discussion into basic, fundamental Oracle architecture and other Oracle App subjects.