I have one SSRS report, text parameter which is in 09-2017 (drop down of all the months in year) format , for default parameter i need load last month load...

In SSRS while setting default value for parameter i am trying to set default value for a parameter has last month and same year (e.g 08-2017)

Any Script to do past 2 weeks monitoring, please suggest

Thanks in advance

Any Troubleshooting/resolution which we can apply to this wait types, please help

As per my understanding from your replies that MEMORY ALLOCATION EXT and  PREEMPTIVE_XE_GETTARGETSTATE not going to be the issue, but still not able to understand the root cause for it ,...

Solarwinds is the tool showing this wait type, anyways to troubleshoot it, please help thanks in advance

this is the statement

Looking at Scale-out best practices

Yes i am seeing more often in User session, which the time increases on daily basis

Frequently getting this MEMORY ALLOCATION EXT wait type ,which takes upto 40 seconds...which comes with another wait type which is happening frequently 

June 14, 2017 at 6:19 am

#1946728

There is any step by step process to do any query issue coming like this on query plan

EXEC sp_create_plan_guide
@name = N'GETSALESPRODUCTS_RECOMPILE_Fix',
@stmt = N'QUERY HERE',
@type = N'SQL',
@module_or_batch = NULL,
@params = N'',
@hints = N'OPTION (RECOMPILE)'

My question whether the...

how to force a query to use particular query plan using plan guide, any sample relevant to this, please reply, thanks

These are the two query plans, please let me know how to solve this

Based on empno i want to concatenate those 3 columns, by using stuff..XML PATH, not required to be in dynamic SQL..Please help me in suggesting the query