Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Any one can send me answers for these Expand / Collapse
Author
Message
Posted Monday, November 17, 2008 7:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 27, 2009 9:36 PM
Points: 5, Visits: 36
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???
Post #604064
Posted Monday, November 17, 2008 9:07 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 36,767, Visits: 31,223
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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #604078
Posted Monday, November 17, 2008 9:40 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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



-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #604089
Posted Monday, November 17, 2008 10:42 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 7, 2011 1:41 AM
Points: 346, Visits: 534
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 ???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
Post #604102
Posted Wednesday, November 19, 2008 4:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 9, 2012 8:02 AM
Points: 34, Visits: 63
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.
Post #605019
Posted Wednesday, November 19, 2008 6:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:03 AM
Points: 1,182, Visits: 1,970
These appear to be "exam" questions and not a current real-world problem.


(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Post #605101
Posted Wednesday, November 19, 2008 7:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 12, 2012 5:46 AM
Points: 1,109, Visits: 279
Try to use Profiler to identify long running queries, or queries with high use of resurces (CPU, Reads, ...)
Post #605108
Posted Wednesday, November 19, 2008 10:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 27, 2009 9:36 PM
Points: 5, Visits: 36
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.
Post #605580
Posted Thursday, November 20, 2008 6:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 15, 2011 2:05 PM
Points: 39, Visits: 65
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
Post #605734
Posted Thursday, November 20, 2008 6:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
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 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

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"
Post #605740
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse