Connecting Tech Pros Worldwide Help | Site Map

Interview type Question

  #1  
Old September 24th, 2008, 02:05 PM
raja
Guest
 
Posts: n/a
Hi,

I am learning sqlserver, my PM asked me the following question, Please
help me on this :

You are a new employee at the company and the only SQL Server 2005
DBA.
You were just informed by the management that one of the SQL Server
cluster environment is performing very badly for about a week now and
that immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.

Please give me ur step-by-step level to proceed for the above
scenario.

Thanks in Advance.
With Regards,
Raja.
  #2  
Old September 24th, 2008, 09:45 PM
Robert Klemme
Guest
 
Posts: n/a

re: Interview type Question


On 24.09.2008 15:01, raja wrote:
Quote:
Hi,
>
I am learning sqlserver, my PM asked me the following question, Please
help me on this :
>
You are a new employee at the company and the only SQL Server 2005
DBA.
You were just informed by the management that one of the SQL Server
cluster environment is performing very badly for about a week now and
that immediate analysis should be conducted.
You are not familiar with the applications or the databases yet, but
they ask you to find the problem as soon as possible.
Please detail your plan of action, tools that you will use along the
process, what would you check and how would you continue if you did
not find any issue at the level or resource you are checking.
Please explain things in a high level along with assumptions and
recommendations.
>
Please give me ur step-by-step level to proceed for the above
scenario.
>
Thanks in Advance.
With Regards,
Raja.
Now what: did he ask you about Oracle or SQL Server? This is
ridiculous. Do your homework yourself!

robert
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interview Type Question raja answers 1 September 24th, 2008 08:55 PM
Tell me ,which type of senior level interview question mohitsaxena1 answers 0 April 17th, 2007 09:24 AM
Cool Interview Questions Link softwareakash@gmail.com answers 2 August 7th, 2006 09:35 PM
stl container for interval data type alex.fishman@gmail.com answers 3 July 4th, 2006 09:35 AM