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

Posted on 2011-04-26
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.
Question by:Bitadmin
    LVL 9

    Accepted Solution


    Author Closing Comment

    Thanks I appreciate the quick response.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now