Any one can send me answers for these

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Any one can send me answers for these

29 posts, Page 1 of 3

1 2 3 »»»

Any one can send me answers for these

Rate Topic

Display Mode

Topic Options

Author

Message

venkat-778920

Posted Monday, November 17, 2008 7:22 PM

Forum 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

Jeff Moden

Posted Monday, November 17, 2008 9:07 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893, Visits: 26,765

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #604078

RBarryYoung

Posted Monday, November 17, 2008 9:40 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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

krayknot

Posted Monday, November 17, 2008 10:42 PM

Old Hand

Group: General Forum Members
Last Login: Friday, October 07, 2011 1:41 AM
Points: 346, Visits: 534

venkat.saginath (11/17/2008)

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

Dennis gibson-431475

Posted Wednesday, November 19, 2008 4:18 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, November 09, 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

Mauve

Posted Wednesday, November 19, 2008 6:58 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 7:07 AM
Points: 1,146, Visits: 1,847

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

j nuñez

Posted Wednesday, November 19, 2008 7:05 AM

Ten 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

venkat-778920

Posted Wednesday, November 19, 2008 10:21 PM

Forum 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

Albert Matubis

Posted Thursday, November 20, 2008 6:14 AM

SSC 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

Perry Whittle

Posted Thursday, November 20, 2008 6:19 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #605740

« Prev Topic | Next Topic »

29 posts, Page 1 of 3

1 2 3 »»»

Permissions