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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply