We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


How can I determine if a SQL Server database is OLTP vs Data Warehouse?

Bitadmin asked
Medium Priority
Last Modified: 2012-05-11
This may sound like a dumb question but I could really use the answer.
I just started work as a Jr. SQL Server DBA with a company in finance industry.
The company has 250+ SQL Server databases, with versions ranging from SQLServer 2000-2008. As you might imagine the company has a variety of applications using these databases.
I am trying to create a inventory database with all the instances and databases along with important statistics on each instance and database so I can manage them all.

My Delimma:
I am new to this industry so I am not familiar with any of the financial applications. I cannot always tell if the sql server database is being used as in OLTP or Data Warehouse mode.
Is there a quick T-SQL or system stored procedure I can use to tell me what mode the server is in? Is the T-SQL /sp different for sql2000-2005-2008?
Thanks for all your help.
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)


Thanks I appreciate the quick response.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.