Long running SP's - sp_prepexec

Hi All:
We have a booking engine for resorts reservations(cold fusion MX and
sql server), our sql server is performing real slow, cpu utilization
is abt 70 -95 % all the time.
Result of Long running SPs contained something like this :
declare @.P1 int set @.P1=NULL declare @.P2 varchar(8000) set @.P2=NULL
exec sp_prepexec @.P1 output, 210, 145, '02/14/04', '02/22/04', 600, 1,
@.P2 output select @.P1, @.P2 151.34 usr001 NULL server_name NULL 65
2003-08-06 11:35:47.733 2003-08-06 11:38:19.077
Please let me know what could be the problem.
Regards
Bhakta RamRam,
Not easy to pinpoint the problem rightaway, especially if its the adhoc
query issue.You can find troubleshooting details here:
HOW TO: Troubleshoot Application Performance with SQL Server
http://www.support.microsoft.com/?id=224587
HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/default.aspx?scid=kb;EN-US;243588
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"BHakta Ram" <bhaktaram@.yahoo.com> wrote in message
news:57bb2f4.0308070727.4a66e989@.posting.google.com...
> Hi All:
> We have a booking engine for resorts reservations(cold fusion MX and
> sql server), our sql server is performing real slow, cpu utilization
> is abt 70 -95 % all the time.
> Result of Long running SPs contained something like this :
> declare @.P1 int set @.P1=NULL declare @.P2 varchar(8000) set @.P2=NULL
> exec sp_prepexec @.P1 output, 210, 145, '02/14/04', '02/22/04', 600, 1,
> @.P2 output select @.P1, @.P2 151.34 usr001 NULL server_name NULL 65
> 2003-08-06 11:35:47.733 2003-08-06 11:38:19.077
> Please let me know what could be the problem.
> Regards
> Bhakta Ram