
	Home > Ask the Oracle Experts > (Archive) Data Warehousing and Business Intelligence Questions & Answers > Measuring offload data

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Measuring offload data

EXPERT RESPONSE FROM: Mike Lampa

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 08 March 2005
This is the situation: We have a large number of MS SQL Server databases in a data warehouse environment. Internal clients (a) query for result sets and (b) select into/DTS/FTP or whatever into their own systems thereby duplicating the data on other systems. The results are: 1. Storage space increase (duplication) and 2. They also use the data but are not charged for the service like the db/system owners. How can we record who, and how much in bytes, offload data from the MS SQL Server databases so that we can charge these "clients"? Are there any simple tools available for this measurement?

EXPERT RESPONSE
I recommend you take a look at Embarcadero's Data Management suite. They have several tools that provide for analysis and statistics as they relate to database management.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	(Archive) Data Warehousing and Business Intelligence
	What is a surrogate key?
	Composite keys in fact tables
	Reducing time to process a query
	Design recommendations for FACT TABLE and DIMENSIONS
	Producing a nested output
	Performing a migration between SQL*Server and Oracle
	Downloading Oracle 10 for Linux
	Migration help needed
	Oracle versus SQL Server for data warehouse
	OLAP defined

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy