tried with 7000000 rows still no difference

Hi

so any query which is not part of procedure or function is considered as adhoc?

Dose this means if we have written such queries in our front end applications these...

Hi All

declare @id int

set @id = 100

select * from xxx where id =@id

if we run this through SSMS , is it considered as adhoc query?

Regrads

Hi Gail

Thanks. My requirement is to get the last few queries which were ran on a particular DB.

How to find it. Note : these quereies could be form application/procedures/SSMS

Regards

Hi Gail

Sorry did not understand your reply.

Regards

Hi

script for extended event is as follows

CREATE EVENT SESSION [xx] ON SERVER

ADD EVENT sqlserver.sql_statement_recompile(SET collect_object_name=(1),collect_statement=(1)

ACTION(sqlserver.database_id,sqlserver.database_name,sqlserver.session_id,sqlserver.sql_text,sqlserver.username))

WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)

GO

Regards

Thanks.

To chekc it, i kept extended event capturing on and executed the procedure. The sql returned 5 rows as "create procedure...". (from your explanation it must be the...

I agree with you. but the query given shows create procedure....So what is it means?

But these quereis are also ran against specific db ( like slect count(*) from xxx) then what does the null db id menas?

dear all

with existing settings when i create new procedure by default quoted identifier for this is 1.

created procedure using -

create procedure aa as

print 'sss'

Checked quoted identifier using -

select *...

chekced it was showing cpu usage more tahn 90% for the sqlserver.exe and the menory ussage was full. We stoped the sql service and restarted then the usage reduced.

This situation...

out put of the query is

10.50.2550.0 SP1 Express Edition with Advanced Services

Thanks. But some times we notics that the server memeory utilization is more then 90%.

How can we check if its due to the SQL db or some other reason. (we...

folloing link shows maximum memory as 1GB http://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx

Dear Hanshi

Thanks for your reply. But if you see my query it has got differnt where clasues for the 2 query hence can not use roll up.

There is no performace...