1. application team complaining that queries are executing slow and want reason for that in this case what should i do [or ] follow
2. customer complaining that the data which they are uploading is taking so much of time and continues to the next time with out completion
(1.) inthis case when they have to upload the next day data customer canelling the previous day data which is still uploding staus
inthis case what should i follow
3..mayin this by cheking sp_who2 active [or ] or using dmvs [or ] dealocks what ever the things which may kill the process in activity monitor
customer dose not want to us to kill any process with out approvalll....
so please guide or suggest us with root cause by that i can handel this issue woludn't repeat again
All that checking for sp_who2, and checkinng the DMV's and using sp_whoisactive is going to do absolutely nothing to solve the problem because people still need to use the database while data is being uploaded, right? The probable reason that the others have queries running so slowly is because of the never-ending upload, so lets concentrate on that first.
1. WHAT are you using to do the upload with?
2. HOW many rows of data need to be uploaded and how wide are they?
3. WHAT is the basic format of those rows? CSV? Text Qualified CSV? Fixed Field/Fixed Length? XML? or ???
4. WHY is the process "pushing" the data instead of "pulling" the data?
5. WHAT kind of error checking and validation are they doing during the upload?
6. Are you uploading one row at a time or are you doing it in batches? If batches, how many rows per batch?
7. WHERE is the data you're uploading in relation to the target server? Separate disks but in same Domain? Same Server? FTP? What???
8. Are the other people's queries still slow if no upload is in the process of uploading?
is pronounced ree-bar and is a Modenism for R
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs