question

rainbow002 avatar image
rainbow002 asked

questions for new database

Hi All, I've seen some posts/articles listing set of questions to be asked by DBA/data center team to clients before hosting their application/db to SQL server. For some reason I'm not able to find it :( sorry about my being lazy...and thanks for your assistance. Here's a few questions I can think from top of my head but I've seen a very detailed post/article with many more questions a while ago: - how big the initial db will be - expected growth in 6/12/24 months for capacity planning - whether application will be internal or external - number of expected users - number of concurrent users - Expectations for availability: what's the desired uptime? - how much data loss can be afforded so we can propose appropriate backup regime Disaster - recovery requirments etc... - security requirements - scalabilty and performance requirements etc...
sql-server
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'm trying to come up with a list of questions for OLAP database. Not known at this point but it's likely that we'd have to use components such as SSAS and SSRS. The initial database (as per an inside leak :)) is around 5-6 TB. What additional questions you guys think I should add to my list?
0 Likes 0 ·
This is the sort of question that confirms to me why I am here to help people. Nice. +1
0 Likes 0 ·
Tim avatar image
Tim answered
You have a really good list stated. I would also ask about the number of transactions per hour if this is an OLTP database so that you can try to properly scale out the resources for RAM and CPU. What about system maintenance. Is there a maintenance window where the system can be offline.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image
TimothyAWiseman answered
I have not seen the article you are mentioning, but you have a good list, but a related one to your expectations of availability is: How significant is unanticipated downtime? It is quite possible to have a database that has large windows for maintenance where it can go down but very low tolerance for any unexpected downtime. On the flip side, you can wind up with a database that you want to be available 24/7 with little to no maintenance window but where a small amount of unexpected downtime is minor and would not justify the costs of some of the extreme high availability techniques out there.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yeah, HA is the one thing that I would have added to the list too.
0 Likes 0 ·
creddy avatar image
creddy answered
Here are my two cents 1. Is cloud storage a requirement such as SQL Azure? 2. What kind of security is required? Kerberos or NTLM
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
[Is this the article you're looking for?][1] Second thoughts, probably not - it's a list of questions to ask a supplier / vendor. Still, it's a good list, and may give you some ideas. [1]: http://www.straightpathsql.com/archives/2009/01/dba-questions-to-ask-a-vendor/
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks. I saw this one before posting my question. I'm pretty sure I had seen a very nicely put together list of questions to be asked by DBA to clients before hosting their database/app on sql server...but not sure if it was this site though.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.