If we had SQL Standard edition, we would be able to setup a maintenance plan in a few clicks. With SQL Express, there is no database maintenance tooling to assist in the completion of tasks such as re-indexing, checkdb, backing up and shrinking the database. We have seen scan times increase from sub one second to over four seconds due to this kind of fragmentation. Because SQL Express only allows a single cpu (or four core) and is limited to 1GB of RAM, the onset of this problem cannot so easily be covered up with hardware. The reason why database maintenance is so important is that, over time, the database will become fragmented and slow. The use of SQL Express requires careful planning and consideration for ongoing maintenance and an understanding of how the database will grow. I have been implementing Microsoft store systems for over 12 years, first with LS Retail and NAV using SQL express and now with Microsoft Dynamics AX and the AX POS.
#Microsoft dynamics pos pricing software#
This is especially true for retailers that have many stores as the compound cost of database software licensing would quickly become cost prohibitive. The answer to the question often boils down to sizing the database for the implementation but it also depends on how you plan on maintaining the remote databases.įrom a client’s perspective, the SQL Express version is attractive because it provides a lot of value for a very low price (free). Of course, the answer that everyone is looking for is “SQL Express”! This is also “supported” by Microsoft but they have not (to my knowledge) every directly recommended using SQL Express in the store. Use at your own risk.įrom time to time I am asked what version of SQL Server the client should use for their store database.
The information in this document does not come with any warranty, express or implied and should not be used as the basis for any business decision. I have included some specific examples in this document that some may rely on to make decisions about sizing the database. Microsoft Dynamics AX – Can I use SQL Express for my Dynamics AX POS Implementation?
0 kommentar(er)
