@Grant

CREATE EVENT SESSION [MySession1] ON SERVER 
ADD EVENT sqlserver.sql_statement_completed(
ACTION(package0.collect_system_time,sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_name,
sqlserver.server_principal_name,sqlserver.sql_text))
ADD TARGET package0.ring_buffer(SET max_memory=(10240))
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


I have a smiliar session which dumps data into...

• This reply was modified 3 years, 4 months ago by  mtz676.

Hi All,

The host name is dependent on the connection string. If people leave this off, it's why you can't audit for it. You can use HOST_NAME to get this information...

@thanks Jeff..I can check the error log way but can I get references on how I can filter the all data but the login records into the .xel...

• This reply was modified 3 years, 4 months ago by  mtz676.

Sounds good to me but unless I am not responding with an answer to the original thread I wasn't sure if it would be appropriate to get into someone's thread...

Thanks @Johan.

I settled with this...

CREATE TABLE #Results (
     abc VARCHAR(MAX)
 )
INSERT INTO #Results
exec sp_msforeachdb '
Select ''
USE [?]
GO
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification ?]
FOR SERVER...

Thank you

No infact it has more memory allocated

@Grant and all

Thank you

@Grant/All,absolutely, the advise I have received from this community has been unparalleled.Learnt a lot from here and I rely more here than the web.

Initially the DB was not a true...

• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.

My bad ,I understand. Thanks again @Grant.

• This reply was modified 3 years, 6 months ago by  mtz676.

@scott,@Grant,@Steve, All

We have again done a straight back and restore across enterprise to standard.Under what circumstances can the execution plans be different.Both instances run on same windows and...

• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.

Stats were never updated on both the versions (standard and enterprise).Both stand 2 years old.Checked some tables which are referred in the stored proc.They stats are the same.

Looks like statistics...

• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.

@steve-2 Jones, @Grant and all,

Thank you.

I have saved the execution plans from enterprise and standard edition. How can I force the stored procedure to use the enterprise plan...

• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.
• This reply was modified 3 years, 6 months ago by  mtz676.

I did nothing.They just became readable.

Thanks

@Steve. Thanks

What settings/config values should be checking in Standard and enterprise (fyi:both on same machine)to troubleshoot this.A back and restore has been done from enterprise to standard, so...

• This reply was modified 3 years, 6 months ago by  mtz676.