thanks guys for your tips
If i need any furthur infomation i will call you here only
in addition to it i would like to know is it good practice to call user's defined function int he stored procedure?
i did that also
is there any way to find what I am looking for
1.HOW QUERIES BEHAVE IN THE SP?
2.HOW MUCH TIME TIME AND HOW...
hey i used
session-------> existing connection
stored procedure -----> rpc complete
and datacolumns are
thanks for u r reply
i used both these
SQLProfilerTSQL_Duration and SQLProfilerStandard
how i can check
On the query...
CAN ANY BODY HELP ME ,
I AM LOOKING FOR ANALYSING AN COMPLEX STORED PROCEDURE, I WANT TO KNOW HOW THE QUERIES BEHAVE IN THE SP .HOW MUCH TIME...
sharepoint is used , i think there is no probs with set up .it is ok.
Hi Derrickleqqett & Satya
I NOTICED THE FOLLOWING INFORMATION FORM THE SERVICES
For your information ,
Basically i awas trying to control the probem of multiple dllhost.exe in the task manager due to the...
I find the following data fort he diffrent counters
Physical disk: Avg. Queue Lengh (should be <= 2 )=max value for this is 0.03...
Thanks Satya and Mmarovic for your intrest in this problem.
I am new to database can you please specify the counter for which I should go?...
But mine main problem is the ever growing size of sqlservr.exe,and then an other instance of the sqlservr.exe. What can be the cause...
Thanks for this information.in my application too the com+ components are in the form of dll and intraction of application request is through dlls...
Is there any relation of sqlservr.exe with dllhost.exe or with IIS ? if any then please let me know.......
Also ,in the Task Manager I have noticed the following:
Process Mem Size VM Size User Name
there is only one that is local.
I am new to databases, can any body tell how many insatance of sqlservr.exe in the taskmanger are possible? And what can cause the multiple...
Separate names with a comma.