Solved

To Create or Not Create new instances

Posted on 2008-10-13
4
201 Views
Last Modified: 2012-05-05
We are currently using Sql Server Standard Ed. Database Eng. for :
-Data Processing: (moderate-high daily transactions, weekly uploads for Report Processing)
-Data Storage: (weekly transactions, source for ReportProcessing)
-Report Processing: (moderate daily transactions [queries], load into non-sql Reporting Software)

1. Related to licensing, overhead [maintenance]) for the above, would it be better to have multiple instances of Sql Server or just one instance?

2. If leave in same instance, best way to manage databases, tables, indexes (partitioning? views?)

0
Comment
Question by:ND_2007
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22706695
it's quite a broad/vague question, but anyhow:

1) it does not matter, in regards to licensing. either you license the end-users/devices (CAL) or the CPU (processor license).
what does matter is how you configure/share the memory usage between the 2, because if you allowed both instances to use all the memory, you will be both instances to crawl like dogs due to paging...

when to use multiple instances, hence: when you NEED to have several instances for different versions/service packs (at least, that is the only real reason I know of)


2) here is where it is vague, or in short has nothing to do with single or multipe instance stuff.
database implementation needs to gather lots of information about the data itself (amount, usage) to know what will be best.
partitioning is a nice feature, but you won't use it on all the tables.
indexing is REALLY a basic feature, but putting indexes on all fields/field combinations is overkill...
views/functions are useful to reduce code, but can be peformance killers...



0
 
LVL 1

Author Comment

by:ND_2007
ID: 22712687
Thanks angelIII for your response, apologies if question not very clear.

Okay here is better explanation of what we are trying to accomplish I hope.
-We want to make it so when you log into sql, you only see production databases or reporting databases.
-Want to allocate resources for production more than reporting
How can we accomplish this is the most efficient manner?
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

828 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