Please post the result of the following script.

select * ...

First try to find the breakup for all the usage. even large number of smaller processes can cause a memory leak. You just need to note the breakup of...

Can you check using this script

select * FROM sys.dm_os_performance_counters

where counter_name = 'Total Server Memory (KB)'

Checking via task manager is not accurate.

As said earlier, u need to find how much...

Have u checked perfrmon or system monitor to find how much memory is used by all applications..You may use "Rammap" utility https://technet.microsoft.com/en-us/library/ff700229.aspx to find which processes are using the...

@steve-2,

The idea struck me when I wanted to read the blogs /articles , stairway series via mobile while I was travelling. Doesn't that sound appealing?;-)

Forums are best suited...

in a sense true, if you want to logically segregate your tables into files or groups of files.

Yes for sure.

Filegroup is in some sense closest to Oracle table space. you can create a file group, assign the space. There is no direct means of assigning permission to just the...

Jack Corbett (5/5/2015)

---

I'd suggest changing the query to get the trace file name from:

select convert(varchar(1000),path) as path from sys.traces where id = 1

To

select convert(varchar(1000),path) as path from...

@Jeff_C

In case, if you haven't read today's article

http://www.sqlservercentral.com/articles/Audit/124740/ 🙂

Guess I am that "someone" whose auditing requirements surprised you 😀

one of the needs for auditing to be async is, in most of the shops, the infrastructure and...

Whether in synchronous or asynconrous commit node , if the Availability Replica is a part of Failover Cluster, Automatic failovers are not supported.

Refer http://msdn.microsoft.com/en-us/library/hh923056.aspx - Page 12 -...

Always on automatic failover from failover cluster instance is not supported.

Yes. Replication was working before but with intermittent error messages. Thanks anyways for your comment.

Thanks. Can you provide some possible reasons - roughly?

I noticed that Network Access have not been enabled for Clustered MSDTC under component services. Is that a possible reason?