Total server memory = 32 GB

only 1 SQL instance

Memory for SQL is 22.4 Gb , the rest of OS

Are plans being flushed from the cache too-> what do u mean...

Thanks for the response

how do I know if it is due to memory leakage in sqlclr code ?

Thanks for the response Jonathan

I executed the query and don't get the expected result

Attached is the result

I cant see the number of queries running

Thanks for the response all

It's 64 bit and No I didn't track Target server Memory . What should I monitor from this counter related from Total server Memory ?

Thanks for your response . Much appreciated

I come across this below article ( I only copy the first point /secret )

"SQL Server Settings Optimization Tips

By Alexander Chigrik

Here are nine "secret"...

Thanks for the response

It is said "The \Paging File(*)% Usage performance counter measures the percentage of usage of each page file. 100 percent usage of a page file does not...

Many thanks All

Thanks mate !

Thanks for the response

dont you rename sa as well ?

Any problem comes up after disabling sa ?

I plan to create a sql account and give it as sys admin previeliege...

HI

Thanks for the response. Much appreciated

I am using SQL 2012 so i assume it is not a bug issue ?

yes I did restart report service after the change

Thanks Guys

Thanks guys . Much appreciated

Thanks for the response .

please kindly answer to my question :

How about if I want to cycle the log every week ?

Does it mean I need to set up the...

HI

Thanks for the response

How do i check if we have witness or not?

Cheers,

Murni

Thanks for the response .

How about if I want to cycle the log every week ?

Does it mean I need to set up the maximum of error log = 12...