That was a good thought. I allocated more than enough memory for the OS. But I still have the same problem.

Yeah, it is a complex query. But there is enough memory on the server(55 Gb allocation to sql server, 16 CPU). With such an amount of memory and processing power,...

You are a genius. Thank you very much. I am able to move forward 🙂

Thanks for your prompt reply. I did exactly as you said. I even checked for permissions on the ISO folder, tried different versions of FreeNAS etc. But still getting the...

I ambitiously started off trying to set up a windows cluster on VMWare and I came across your wonderful article. I am stuck on a small issue though. I am...

If you query the system table sys.tables, you should have all the info you are looking for.

http://sqlblog.com/blogs/elisabeth_redei/archive/2009/03/01/bufferpool-performance-counters.aspx.

This link should have all the information you are looking for.

I would try a third party tool

Is your issue resolved?

If you want to do a check for backup failures, you can query the backup set to find out the databases for which backup hasn't been taken. I hope the...

You might have already done this. I would try to check the service account that the agent is running under to see if it has the right permissions to access...

You need to install the OS on C:\ which is a local drive. You can install SQL server on the local drive D:\ and you need to come up with...

Reindexing cannot be done on sp_tables as it is system stored procedure. Does the second server you are querying has exactly the same tables as the first server? Also, it...