Thanks Anthony!

https://msdn.microsoft.com/en-us/library/ms143724(v=sql.120).aspx

Above article says we cannot rename reporting database name. Could you be able to shed some light on the following:

*How to migrate the existing reporting database.?

*On new instance can...

Thanks!

Thanks Gail!

Thanks Gail. Lock pages in memory is enabled.

Thanks Gail!

Total server memory used when checking perfmon counter is: 100 GB

But there is additional usage by sqlserver.exe of 24 gb more as 'private working set' showing in...

Max memory means maximum memory that can be used, not memory that is actually being used. So just because max memory is set to 100GB, doesn't mean you're using 100GB.

My...

There is 4 GB left out of 128 GB total.

here's the breakdown:

target sql memory: 100 GB

+

'sqlserver.exe' memory usage on RAMMAP: 24 GB

=

124 GB used

--24GB extra used on top of...

Hi John, Sorry if my description was not good enough.

Here is more in detail:

Windows server 2012 R2

SQL server 2014 Enterprise(2 node cluster)

Total memory for windows server: 128 GB

Max SQL...

Yes Grant, Its using 24 GB more than the max memory set for it.

Thanks Raj. The total server memory is 100GB. RAMMAP shows 'sqlservr.exe' as the top process (24GB).

Hi Raj, total server memory is 100GB. RAMMAP shows 'sqlserver.exe' as the top process (24 GB).

'sqlservr.exe' is using 24 GB of memory which is the top on the list.

Also I noticed that the available memory has dropped from 4 GB to 1 GB when 'RamMap'...

Thanks Grant. But the memory usage has exceeded 24 GB over the max memory set for sql which is 100GB.

Thanks Raj. File stream is not enabled. Also there are no ssis packages or other applications installed.

Thanks John. The max memory value is 100GB.