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]