August 28, 2012 at 5:49 am
A scenario will be assigned to me in some days...
We have a Database & a Application...
Now a user opens the application & enters the data in it.. now while fetching the data every time it takes long time 🙁
& so we DBA are been pointed as this is a DB issue...
Dont know.. but while surfing google... i came to know that this problem may be due to CPU or I/O or other..
I found some quieries in google through which we can track the actuall issue..( dont know if this is right :w00t:)
USE MASTER
SELECT * FROM MASTER..SYSPROCESSES
SP_WHO2(SPID)
DBCC INPUTBUFFER(SPID)
Can anyone please help as to how to solve & track this problem & make the DB use smooth so that the application which runs through it would run fast????
How to solve this..
Even after using the above queries i am not able to understand as to what should i look in it & how to understand the meaning of each of them??????
************************************
Every Dog has a Tail !!!!! :-D
August 28, 2012 at 5:54 am
If it's critically important and no one has performance tuning experience you may need to hire a consultant.
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
August 28, 2012 at 5:59 am
If you know already which query is running slowly, you could post it here & let people have a look at it.
It might have obvious problems which could be pointed out.
Slow queries are often caused by tables not having the correct indexes to support them, but there are code constructs which slow queries too.
August 28, 2012 at 6:06 am
I dont know the exact query.. but the network team says that its a DB issue & you should look into it..
How do i confirm whether its a DB issue or CPU, I/O or a Slow processor issue..
************************************
Every Dog has a Tail !!!!! :-D
August 28, 2012 at 6:19 am
The two links given above by Gail are exactly what you need at this point of time. Go through those links, they will help you to get the queries that are running slow. Once you get those queries, you can go through their execution plans to identify the problem.
Regarding the sp_who2 you talked above, it is a system stored procedure which provides information of currently running sessions.
DBCC inputbuffer (@SPID) gives you the command text of the supplied SPID.
August 28, 2012 at 6:26 am
Thanks All 🙂 i will follow your answers :-):-)
************************************
Every Dog has a Tail !!!!! :-D
August 28, 2012 at 6:42 am
Seriously, if this is a critical problem and you don't have any knowledge of performance tuning, get someone in to help.
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
August 28, 2012 at 7:23 am
GilaMonster (8/28/2012)
Seriously, if this is a critical problem and you don't have any knowledge of performance tuning, get someone in to help.
Hi Gail,
Na its not that serious as of now.. as the data is not that huge.. yes but little huge...
Here at our end they are not in process of hiring any Expert DBA in this & so i have been asked to do this,
I have authority to do it as i want...
Current scenario at my end..
1 Production DB & another Reporting DB..
All the data from Production is transferred to reporting DB & the reports are fetched on it..
BUt the application uses the production DB as there are some updates to be made on it & while doing so the pages are slow... it occurs sometime & not every time..
But this is a golden opportunity for me to learn & implement this here alone..
Would require your help & suggestion to do this...
(Basically for years this was never asked & done.. but as i am working here having minimum knowledge can implement this will be beneficial for organization & my growth)
Will write all scenarios as i start doing this & i am sure i will be stuck in all times 🙁
But i wish to make this so that that will add in my resume ... so i took up the opportunity to work this tasks like Performance, Log Shipping & DB mirroring... 🙂
I went through the link you posted for me.. really its awesome 🙂 Hats off to you...
But still i would need your help on every move i am stuck 🙁
************************************
Every Dog has a Tail !!!!! :-D
August 28, 2012 at 8:35 am
You can post your problems here and people will probably help you. That said it sounds like you're asking for free consulting....
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
August 28, 2012 at 10:19 am
GilaMonster (8/28/2012)
You can post your problems here and people will probably help you. That said it sounds like you're asking for free consulting....
Heh, all problems are serious until you have to spend money on them... 😀
[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]
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply