Friday , December 15 2017
Home / DBA Interview Questions / MSSQL DBA Interview Questions from FIS Company

MSSQL DBA Interview Questions from FIS Company

MSSQL DBA Interview Questions

1)How you can find system low process ?

Example :- You came to Shift at 2:00 Pm , But your manager is asking process report for early 6AM report ? How you can pull past reports means Historical Reports ? How many ways you can find ?

2)What is Resource Governor ?

How you can set Max – Min CPU, Memory ? What is the DMV to finding about this ?

3)While Migration to New Server, What Prequestics to take it for tempdb configuration ?

4) For Tranasctional replication with out snapshot how you will configure with out starting snapshot ?

5) How you can find any broken links in replication, Is their any DMV’s?

6) Tempdb full what action, you can take ? How you can find which process is impacting tempdb ?

7) Client is asking Server is slow, What steps you will take it ? any DMV’s are their ?

 

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Comments

comments

Check Also

SQLDBA Interview Questions in CGI bangalore

SQLDBA Interview Questions in CGI What is inline memory ? In which version they introduced ? Suppose …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe