Well, let's see:
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
While @i < 99
Insert into Users
Select 99, 'Loopy', 'Lou', 9.11;
Delete from Users Where UserID=99;
Select @i =+ 1;
, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."