|
December, 2005
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
The Limits and Limitlessness of Time Oracle performance analysis has come a long way in the last 20 years. First, there was the “just add more resources” approach, then there was ratio analysis, and finally wait event analysis. But that was not complete or broad enough, so in 2001 I published my Oracle Response Time Analysis (RTA) paper. The RTA paper brought together and detailed the two elements of response time, that is, service time and queue time. One of the more subtle aspects of RTA is understanding the relationship between service time and queue time and how that relates to the operating system.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
DDF – Mainframe DB2’s Window to the World When the Distributed Data Facility made its debut, the development team was thinking primarily about data federation – about providing a means whereby organizations using mainframe DB2 (keep in mind that DB2 for Unix and PC platforms did not arrive until 1993, and initially ran only with OS/2 and AIX) could “virtualize” the actual location of tables in different databases on different servers. The initial DB2-to-DB2 communication mechanism provided through DDF was called private protocol. It allowed a program local to the DB2 subsystem on mainframe A to access a DB2 table on mainframe B by way of a three-part name (location.owner.table-name). A DBA could define an alias on the local DB2 subsystem and associate it with the fully-qualified three-part name of the DB2 table on mainframe B, thereby making the remote table appear to local programs as a table in the local DB2 database; thus, the DDF made it very easy to tie together objects spread across multiple (and perhaps geographically dispersed) mainframe DB2 subsystems.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
Altering Replicated Articles in SQL Server 2005
One of the fairly frequently asked questions on the Microsoft replication
discussion boards concerns how to alter a replicated article. For simple cases
this is quite straightforward - adding a column is achieved using
sp_repladdcolumn, while sp_repldropcolumn is used to drop a column. However,
what if we want to change an existing column - eg change the Fname varchar(50)
column below to Fname varchar(100)?
Click here to see this article.
Dynamic Management Objects Performance tuning and troubleshooting in SQL Server has always been
something of a black art. To be effective at it you need to know how to use a
large set of tools, including Profiler, Perfmon, DBCC commands and stored
procedures. Sometimes it can seem almost random which tool you should use for a
specific issue. They will often affect performance themselves, so you might not
always be able to use them. Another problem is undocumented DBCC commands or
system tables. More or less everyone who knows something about tuning know and
use a couple of these. But the advice has always been that you should not use
these unless you really know what you are doing or you are told to use them by a
Microsoft support professional. For all of these reasons SQL Server 2000 can be
seen as a black box that can be quite difficult to penetrate. SQL Server 2005
changes all this by introducing the new Dynamic Management Objects.
Click here to see this article.
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world. | ||||||||||||||||
|
||||||||||||||||
|
Using and Tuning of the Query Cache MySQL provides a mechanism to cache a query and its result set for reuse by all users. This can be extremely effective in environments where a large number of small, lexically equivalent queries are repeated often.
Click here to see this article. | ||||||||||||||||
|
||||||||||||||||
Pareto Analysis can be used when you encounter multiple related problems or a common problem with multiple causes. In this technique you are also need to be able to collect metrics on how many times each problem or cause occurs. The purpose of Pareto Analysis is to observe the problems and determine their frequency of occurrence. This, in turn, gives you the information you need to prioritize your effort to ensure you are spending your time where it will have the most positive impact. Click here for more information on Pareto analysis. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Fun with Phrases"
|
||||||||||||||||
|
||||||||||||||||
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please visit http://qlist01.quest.com/UnsubMailingList/ Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
||||||||||||||||
