Search Results | SQL Server Performance Forums

STORED PROCEDURE ANALYSIS

Post by: HHAAPPYY, Jan 21, 2005 in forum: T-SQL Performance Tuning for Developers

thanks guys for your tips If i need any furthur infomation i will call you here only thanks HHAAPPYY

STORED PROCEDURE ANALYSIS

Post by: HHAAPPYY, Jan 20, 2005 in forum: T-SQL Performance Tuning for Developers

in addition to it i would like to know is it good practice to call user's defined function int he stored procedure? thanks HAPPY

STORED PROCEDURE ANALYSIS

Post by: HHAAPPYY, Jan 20, 2005 in forum: T-SQL Performance Tuning for Developers

thanks Luis 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...

STORED PROCEDURE ANALYSIS

Post by: HHAAPPYY, Jan 20, 2005 in forum: T-SQL Performance Tuning for Developers

hey i used session-------> existing connection stored procedure -----> rpc complete TSQL--> BatchComplete and datacolumns are event...

STORED PROCEDURE ANALYSIS

Post by: HHAAPPYY, Jan 20, 2005 in forum: T-SQL Performance Tuning for Developers

hi satya thanks for u r reply i used both these SQLProfilerTSQL_Duration and SQLProfilerStandard how i can check On the query...

STORED PROCEDURE ANALYSIS

Thread by: HHAAPPYY, Jan 20, 2005, 10 replies, in forum: T-SQL Performance Tuning for Developers

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

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 7, 2005 in forum: Performance Tuning for Hardware Configurations

sharepoint is used , i think there is no probs with set up .it is ok.

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 7, 2005 in forum: Performance Tuning for Hardware Configurations

Hi Derrickleqqett & Satya I NOTICED THE FOLLOWING INFORMATION FORM THE SERVICES MSSQLSERVER ...............STARTED...

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 6, 2005 in forum: Performance Tuning for Hardware Configurations

Thanks Luis For your information , Basically i awas trying to control the probem of multiple dllhost.exe in the task manager due to the...

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 6, 2005 in forum: Performance Tuning for Hardware Configurations

Hi Luis I find the following data fort he diffrent counters Physical disk: Avg. Queue Lengh (should be <= 2 )=max value for this is 0.03...

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 6, 2005 in forum: Performance Tuning for Hardware Configurations

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

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 6, 2005 in forum: Performance Tuning for Hardware Configurations

Thanks Satya 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...

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 5, 2005 in forum: Performance Tuning for Hardware Configurations

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

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 5, 2005 in forum: Performance Tuning for Hardware Configurations

Hi Is there any relation of sqlservr.exe with dllhost.exe or with IIS ? if any then please let me know.......

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 5, 2005 in forum: Performance Tuning for Hardware Configurations

Also ,in the Task Manager I have noticed the following: Process Mem Size VM Size User Name Sqlservr.exe...

MULTIPLE sqlservr.exe in Taskmanager

Post by: HHAAPPYY, Jan 5, 2005 in forum: Performance Tuning for Hardware Configurations

Thanks Luis there is only one that is local.

MULTIPLE sqlservr.exe in Taskmanager

Thread by: HHAAPPYY, Jan 5, 2005, 23 replies, in forum: Performance Tuning for Hardware Configurations

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