November 17, 2008 at 7:22 pm
If the user complaint you that application is running very slow. As
a DBA where do you start your work ???how do you find where exactly
the problem is???
After logshipping configured,users are connecting secondary
server...how can you disconnect them?
Log file size increasing ,..even after logshipping connfigured??
what could be the reason?
what are the configuration changes before and after installing sql server service pack???
November 17, 2008 at 9:07 pm
Those are pretty standard interview questions and you'll probably find the answers simply by googling them. Look for "SQL Server Interview Questions". But, beware... if you get hired just by answering questions you memorized the answers to, you will be in very deep Kimchie in about 45 days because you won't know enough to actually do the job.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2008 at 9:40 pm
Well, let's see:
venkat.saginath (11/17/2008)
If the user complaint you that application is running very slow. As a DBA where do you start your work ???
Usually on my cell phone as I am driving to work.
how do you find where exactly the problem is???
Get a red felt tip pen and your office's floor plan. Find your boss's office, circle it. Done.
After logshipping configured,users are connecting secondary server...how can you disconnect them?
A good pair of cable-cutters will do it.
Log file size increasing ,..even after logshipping connfigured?? what could be the reason?
Probably some annoying user running this procedure that I gave them last week to get rid of them:Declare @i as int
Set @i = 0
Begin Transaction
While @i < 99
Begin
Insert into Users
Select 99, 'Loopy', 'Lou', 9.11;
Delete from Users Where UserID=99;
Select @i =+ 1;
End
Commit
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 17, 2008 at 10:42 pm
venkat.saginath (11/17/2008)
If the user complaint you that application is running very slow. Asa DBA where do you start your work ???how do you find where exactly
the problem is???
After logshipping configured,users are connecting secondary
server...how can you disconnect them?
Log file size increasing ,..even after logshipping connfigured??
what could be the reason?
what are the configuration changes before and after installing sql server service pack???
1. check the modules in the application wher ethe problem is.
2. check the asssociated tables with that module.
3. start to work on those tables.
4. first try to optimize the queries. and if the same problem persists thne do any heavy tasks
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 19, 2008 at 4:18 am
Depends if the app is web based or a console application. It also depends on what they are running on their desktop, how much memory is available on the desktop, is the desktop low on space. I always check these items first because they are usually the problem way before the database. Especially if it is one user. Start with the basics first I say.
November 19, 2008 at 6:58 am
These appear to be "exam" questions and not a current real-world problem.
November 19, 2008 at 7:05 am
Try to use Profiler to identify long running queries, or queries with high use of resurces (CPU, Reads, ...)
November 19, 2008 at 10:21 pm
Hello Mister
I don't know who you are? And remind one thing may be you are not a Database Administrator because of as a DBA they must answer as they faced and they know in their organization and I am also faces such kined of problems in my organization. You are not a DBA as I think.
November 20, 2008 at 6:14 am
If the user complaint you that application is running very slow. As
a DBA where do you start your work ???how do you find where exactly
the problem is???
As for me I used the perfmon, profiler and activity monitor to find out where the problem is. To detect I/O bottleneck use the Perfmon and monitor the processor, CPU, memory and Disk I/O. Use the Activity monitor to detect blocking processes that occurs on the database (which is the common problem). Use the profiler to detect Queries/batch that are causing the slow performance of the database.
After logshipping configured,users are connecting secondary
server...how can you disconnect them?
Before the logshipping job restore the transaction logs it should kill all processes that are currently running on the database otherwise the restoration will fail and it will return an error like "Cannot hold exclusive access to the database.."
Log file size increasing ,..even after logshipping configured??
what could be the reason?
database log file will eventually increase in time depending on the frequency of data modification on the database
what are the configuration changes before and after installing sql server service pack???
see microsoft for details...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
November 20, 2008 at 6:19 am
rbarryyoung (11/17/2008)
Well, let's see:venkat.saginath (11/17/2008)
If the user complaint you that application is running very slow. As a DBA where do you start your work ???Usually on my cell phone as I am driving to work.
wow, i'm normally still in bed at that point, you must be keen
rbarryyoung (11/17/2008)
how do you find where exactly the problem is???
Get a red felt tip pen and your office's floor plan. Find your boss's office, circle it. Done.
i prefer green felt tip
rbarryyoung (11/17/2008)
After logshipping configured,users are connecting secondary server...how can you disconnect them?
A good pair of cable-cutters will do it.
i prefer to just inconspicuously pull the rj45 plug out of the back, its extremely aggitating trying to connect all the little wires up to crimp on a new plug again when someone spots the broken cable
rbarryyoung (11/17/2008)
Log file size increasing ,..even after logshipping connfigured?? what could be the reason?
Probably some annoying user running this procedure that I gave them last week to get rid of them:
Declare @i as intSet @i = 0
Begin Transaction
While @i < 99
Begin
Insert into Users
Select 99, 'Loopy', 'Lou', 9.11;
Delete from Users Where UserID=99;
Select @i =+ 1;
End
Commit
ahh so you're the one passing this little beauty around are you 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 7:52 pm
venkat (11/19/2008)
Hello MisterI don't know who you are? And remind one thing may be you are not a Database Administrator because of as a DBA they must answer as they faced and they know in their organization and I am also faces such kined of problems in my organization. You are not a DBA as I think.
Heh... folks are just having a little fun with you because you've obviously not done much work on your own on this. The questions you asked are inteview questions designed to test your actual experience. They're designed to find out if "You are not a DBA as I think."
Couple of things you should be aware of... real DBA's don't answer interview questions for other folks.
The other thing is, you should never trust what you find on the WEB. If you answered the questions the way some of the more serious folks did on this thread, I wouldn't hire you because some of the answers don't really answer the question asked, and 1 of the answers is dead wrong for multiple reasons.
So, I recommend you spend more time doing the proper research in Books Online than you did with the remarks you made out of extreme frustration. Not making fun of you here... you need to do the research to earn your stripes on interview questions.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2008 at 5:03 am
venkat (11/17/2008)
If the user complaint you that application is running very slow. As a DBA where do you start your work ???how do you find where exactly the problem is???
Tell them the application code is poorly written and to leave you alone - the database would be fine and fast without all these pesky applications accessing it 😀
venkat (11/17/2008)
After logshipping configured,users are connecting secondaryserver...how can you disconnect them?
Upgrade to SQL2005 and use database mirroring 😀
venkat (11/17/2008)
Log file size increasing ,..even after logshipping connfigured?? what could be the reason?
Buy bigger disks, thereby eliminating file growth as a DBA problem. It becomes SEP 😀
venkat (11/17/2008)
what are the configuration changes before and after installing sql server service pack???
Before it had "Allow hacks from Internet" option ticked
After it has this option un-ticked but the "Crash randomly" option ticked. :w00t:
November 21, 2008 at 8:33 pm
Hi,
Well this is not right to think of you. I may sending questions those r not interview questions those r i was faced in my organization n few more would be asking for my Team Lead . so thats what I'm says.
And one more I know everything about your surfing process but i don't have time to surfing. Do you know I'm a Sr. DBA. Some times I am full bizzi thats why I'm sending forum response for finding easiest and fastest way.
November 21, 2008 at 9:59 pm
There be trolls about!
November 22, 2008 at 12:15 am
venkat (11/21/2008)
Hi,Do you know I'm a Sr. DBA. Some times I am full bizzi thats why I'm sending forum response for finding easiest and fastest way.
A senior DBA who doesn't know how to do performance monitoring or how to kill a connection? I could accept that of a junior with only a couple years experience maybe.
May I suggest that you ask your boss for some good SQL courses?
If you don't have time to keep up with the technology and keep learning about the technology, then there's something wrong. We all need to do that or we'll be useless as technology changes.
Asking on the forums is fine and we'll try and help as much as we can. A post with just a set of unrelated questions and no background info looks like homework or interview questions and most of us won't answer those. If you have a question, post it and give as much context and info as you can. It's hard to provide an answer without that information.
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
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply