I have a Windows Server 2012 with rather slow hard-drives BUT with a lot of RAM and I can't change that (it's an Amazon EC2 actually).
What can I do to optimize performance?
I have 16 GB of physical memory but 5-6 GB of it always stay free. Should I increase disk-cache size? Or maybe disable the page file? Or make it fixed size? Interested in general Windows tuning tips, possibly not involving "buy a faster drive from Amazon" :)
PS. The server runs an IIS web-server (intensively used) and an SQL-server with one small (6GB) database. SQL already uses 7GB (looks like all the DB is already cached there).
Thanks guys!
There is nothing you CAN do. Disc cache size - Windows automatically uses all non-app-allocated memory, so - there you go. Page file - should not do a lot anyway (only swap out stuff really not used). Slow databases with SQL Server are just not working.
On top, SQL uses it's own caching anyway..... unless you sabotaged that one.
What you can do is update SQL Server to 2014 and activate the delayed logging option, which gives you better performance at the cost of possible transaction losses.
At the end, a database does need fast IO if it does a lot of work, and no magic wand will work around that ;)