April 28, 2014 at 3:25 am
Hello,
This might seem like an odd question, as this is the 1st company where most of our IT servicers are outsourced and I am the only DBA/VB/VBA even macros etc....
I just found out that one critical priece of software is shared with, as they described it "I don't now what other software runs on this DB"
The short story is, we had many times when the DB "choked" but thery say all the other databases ran fine (this was during Easter holiday, 5 days here). They claimed the only problem was with this database (but was anyone running anything else??) and to boot they do not even tell me what else uns on this MSSQL instance.
Long story short, how can I explain then need for at least a dedicated instance as we have "choked" many times and, at leat for this DB, I am not the admin (nor do I want to be when I have no idea what else is running).....but I must make the case in simple English (or Norwegian) as to why a critical DB should be seperated (and add some RAM etc if needed).....
Any ideas how to get the bosses in my corner?
Tusen takk,,
Dave
April 28, 2014 at 3:48 am
Maybe try a metaphor.
A very busy businessman has a few kids.
He can either drive them around town with his car to bring them to school et cetera and waste a lot of time before he can start his own job.
Or he can give his kids bikes and let them ride themselves to school, while he has the time to do his job.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 28, 2014 at 4:21 am
First find out what are other applications are running on the server alongwith SQL Server. Than refer the Microsoft best practice document to have dedicated SQL Server database instance/server. Produce it to the client as a reference.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 4:57 am
Thanks for the relplies. Unfortunately, for this particular DB it is more like Software as a Service and I do not know how much access they will give me. Mostly it will be billed for them to monitor and since this database instance has DBs from other companies, I doubt I will get any high-level access which is why I want it to be a dedicated instance just for this software which is critical and very often little used or maxing out (I believe) but without being able to get the facts straight, it is not helpful that they say "all the other databases were working fine over the 5 day Easter holiday" while 99% of the people were on vacation and we were on a tight deadline. I do like the bike analogy though....and since I am the only DBA/IT/Finance person internally many people I talk to are lost when I speak of "instances" and "stress testing" which is not a good idea to do on a full holiday when maybe only our one app was really running at any significant capacity.
Thnaks,
Dave
April 28, 2014 at 6:01 am
Another good option to start with is sql or windows error log. Try to find out what kind of error message it has captured at the time of the issue this might give you some hint.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply