Clamp Memory to about 75-80% of total Memory in SQL 2012 and higher.Allow tempdb room for expansion of the disk.Separate SQL Server, SQL Data and SQL Log files into separate partitions (spindles, if possible).However, here are some general guidelines. There are many sites dedicated to server and query optimization, most are great and can be rather detailed. SQL Server 2016 (and later) Edition ComparisonsĪ side note for developers SQL 2016 “Developer” (was free last time I checked) and fully functional, but for development only, NOT for Production.I believe, you have options as to the version compatibility (see WW Notes below), but SQL 2016 has more reporting capability in SSRS than before, like dashboards. I would guess that for most clients/customers that are using Historian out-of-the-box this is fine, but for extensibility no SQL Agent could be a blow. In Express versions the SQL Server Agent is not supported, nor is the SQL Profiler, no SSIS designer and runtime, and no email are key takeaways. There is also a database size and configuration limitations (see limitation links below), but The Historian Database does not get big only the Extension tables do and they are files external to the database.
The Tier 1 Historians can use Express as long as the tag count does not exceed 50k (I believe?).The Tier 2 Historian must have full version because we/others probably want to use the SQL Agent to harvest KPI other information from the Historian tags, and in time it could be bigger.It is very capable these days in my opinion: SQL Server 2014 SP2 Express with Advanced Services.SQL Server 2014 SP1 Express with Advanced Services.
The System Platform, Historian, and DEV Studio will continue to include MS SQL Server Standard & CAL Licenses. Therefore, Microsoft SQL Server Standard license will not be included in 2017 System Platform, System Platform Starters, Historian, Dev Studio, Advanced Studio sizes 25000 and smaller and will not be included in 2017 Information Server. The removal of Microsoft SQL Server Standard license in larger size Wonderware products that was announced on Februcontinues with the 2017 release. Microsoft SQL Server with Wonderware Products plus References ( … this will likely be dated in a few years)
0 kommentar(er)
