CLR is enabled and the server holds linked servers. Maxdop setting is 4. For CPU settings, both processor affinity mask and i/o affinity mask were checked. We also have...

I went through all the logs and grabbed some info for you guys. The following links gives us the exact scenario which happened at that time.....

Error 1: There was a...

I am trying to find the exact reason behind why the server behaved like this....

any suggestions?

Nope. I never ran the checkpoint stmnt.

Yes Perry is right. I mean DBCC DROPCLEANBUFFERS. Edited the previous post.

lock pages in memory set for sql server service account. No traces running.

My assumption is the accumulation of memory by sql server was at a slower pace than the memory required for the queries to run on the server at that time....

The sql services got restarted by itself. It didn't failed over to other node. The services got restarted on the same instance. We tried to run the dbcc DROPCLEANBUFFERS ...

Jeff Moden (2/27/2014)

---

muthyala_51 (2/27/2014)

---

i am not making the database into single user mode. I just leave the latest partition to read write and change the rest of the filegroups to...

i am not making the database into single user mode. I just leave the latest partition to read write and change the rest of the filegroups to read only. As...

Steve Jones - SSC Editor (2/27/2014)

---

Are you saying you can add data to the partitions that are marked as read-only in the filegroups? It's possible there is a bug here...

Any suggestions ???

jjmanthei05 (2/27/2014)

---

Last night we had an incredibly large log file generated that log ships between our servers (2.5 gig). I am working on figuring out what caused it but my...

I tested the process quoted by you. It worked fine but the problem is now I can also insert data into read only files.

select name,is_read_only from sys.filegroups

PRIMARY ...