November 29, 2018 at 10:26 pm
What questions do I need to ask the business when preparing an table and query against which a report query will be running: ie. usage patterns (number of users, frequency of report usage, and peak usage hours, table growth) . Are these all valid questions???
--Quote me
December 4, 2018 at 12:04 pm
polkadot - Thursday, November 29, 2018 10:26 PMWhat questions do I need to ask the business when preparing an table and query against which a report query will be running: ie. usage patterns (number of users, frequency of report usage, and peak usage hours, table growth) . Are these all valid questions???
Yes those are valid questions, apart from those you can also ask:
what will be the initial size of the database, how much would the database grow in the next 3 years.
Do you need any specify permissions assigned to the users.
How many users will be connected to the database at the peak time.
How do you need the backup to be configured? like Full, Log, Differential , based on this you can model the Recovery Model of the database.
Also hope the user will know how to link the tables within the database and set the relation ship between them
December 10, 2018 at 8:29 am
polkadot - Tuesday, December 4, 2018 5:59 PM@Rinu Philip
if I know how many users will connect to the query (running SSRS report and pass parameters) how can I test whether the performance will still be just as when only one user?
Please suggest search terms or any internet sources.
I don't see anyone answering this, primarily because if anyone could know such an answer easily, it could have already been programmed into a system at a low level and the system could predictively suggest configuration upgrades to handle the load, or be given a set of parameters that it could use to pre-calculate load. So here's a quick poem that says it all:
You can't know the answer to this in advance,
so you'll just have to fly by the seat of your pants.
No, this is not any one of my rants. ...
it's only 'cause I already know this dance.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply