ofcourse., there is no where near comparision between 2 fusioio is pure flshbased and nimble is hybrid solution where it use flash only for caching and rest on traditional disks.

Yes, could be if your files stored in that drives or LUNS.

Is the users get authenticated at the application or database ? if at application changing the the access on only application account that connects database will be fine else...

sounds like you never created one sa account in your server., changing it to mixewd mode after installation does not create sa account automatically ! you should have a option...

seems like the package was moved from the location it has. restart the sql agent and see if it works. --Just a tip

If you are using them in the where clauses then the stats will auto created and you might know it already and you really do not have control on it....

How does the application calls these columns ? If it is calling through a SP then the changes can be done on dB side only else a ad-hoc quey calls...

you can use something like this

If you have the sql server hosted in different domain than from where you are trying to connect then it is one of the...

You can justify as , Always on replica's are online for read-only purpose and you can off load some of the tasks like backup and reporting (if you have one)...

Few days I was asked to test the nimble storage for sql server as we are planning to buy nimble in large quantity

Here are the SQLIO test results on CS460...

Good Artcle !

The same can be achived with some additional results from teh activity monitor script where it has the root blocker .

You can get the script in this way...

Thank you Jeff, definitely helps.

In addition,I was thinking of a load test resource bottlenecks before going to live with some software which can create the virtual users, For example hammerdb...

No, this was an interview question, 1 TB is just an assumption that database will grow upto 1 TB in next one month and we should scale the server to...

That is kind of direct route to the issue ..fixed.

Thank you..Great Article.

Are you using a script to do this backup ? why there is double slashes '\\' ? seems the path it was trying to...