December 19, 2013 at 8:25 pm
Dear All ,
Can any one give answers for these I will be thank full if so
1. how will you do san migration of sqlserver clusternodes
2. wait stats types
3. how will you do query tuning
4. diff between logshipping and mirroring
5. blocking occurs what will you do and how will you trouble shoot
6. 2000 users running how will you find out and rectify the long running query and how will you resolve
or
slow running queries and there are 2000 users [process running ] application team complaining application is running slow
7. nested loop execution
8. cluster A and B nodes
A node is having 1,2,3 instances
B node is having 4,5 instance
i want to move 1 instance from node A to B node and
how will you rename the instance after moving from A to B node
9.without down time i want to move a instance of cluster node A to
cluster node of B
Thanks
Naga.Rohitkumar
December 20, 2013 at 12:11 am
naga.rohitkumar (12/19/2013)
1. how will you do san migration of sqlserver clusternodes
A little vague and will depend on the SAN. Best to speak with the SAN admin and identify exactly what needs to be done and how
2. wait stats types
What about them?
3. how will you do query tuning
5. blocking occurs what will you do and how will you trouble shoot
Chapter 6: http://www.red-gate.com/community/books/accidental-dba
6. 2000 users running how will you find out and rectify the long running query and how will you resolve
or
slow running queries and there are 2000 users [process running ] application team complaining application is running slow
Same way you'd tune for any other number of users.
7. nested loop execution
What about it?
8. cluster A and B nodes
A node is having 1,2,3 instances
B node is having 4,5 instance
i want to move 1 instance from node A to B node and
how will you rename the instance after moving from A to B node
You can't rename instances, you can rename the server, in this case the cluster virtual name and that's done through cluster admin or in windows.
9.without down time i want to move a instance of cluster node A to
cluster node of B
Can't be done, there's always downtime, even if it's just a few seconds
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2013 at 4:09 am
This really sounds like a job interview. If so, you ought to be able to 1) Answer these questions for yourself 2) Look them up through Google or Bing or whatever on your own. If this is for a job interview, remember, you're going to be expected to deal with things like this, on your own, possibly in the middle of the night and that business will be depending on your to ensure they stay online and retain all their data.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply