Archive for the ‘SharePoint and EPM’ category

April 24th, 2023

Microsoft 365 Copilot combines the power of large language models (LLMs) with your data in the Microsoft Graph and the Microsoft 365 apps to turn your words into the most powerful productivity tool on the planet.

Microsoft Graph is the gateway to data and intelligence in Microsoft 365. It provides a unified programmability model to access the tremendous amount of data in Microsoft 365, Windows, and Enterprise Mobility + Security. Use the wealth of data in Microsoft Graph to build apps for organizations and consumers that interact with millions of users. Custom applications can use the Microsoft Graph API to connect to data and use it in custom applications to enhance organizational productivity.

Microsoft Graph provides a single endpoint that the app can use to access the required data and to simplify the overall development process.

Organizations store vast amounts of data and intelligence across Microsoft cloud services, but how accessible is the data to users?

For example, a salesperson is setting up a meeting with a customer, wants to easily access files and previous meetings and notes but are those emails and chats between a salesperson and customer easy to find? What people within the organization can the customer contact for support?

Data and intelligence like the following types can be accessed through the Microsoft Graph REST APIs and client libraries:

  • Users and groups
  • Teams data
  • Tasks
  • Files
  • Mail
  • Meetings and calendars
  • Organizational charts

Copilot is an AI-powered tool that uses natural language processing and machine learning to understand users’ requests and provide personalized recommendations, tips, and assistance. Users can ask Copilot questions and get instant answers, guidance, and suggestions to help them work more efficiently.

Copilot is designed to be available across multiple Microsoft 365 applications, including :Word, Excel, PowerPoint, Teams and Outlook, and is intended to be context-aware. It ‘understands’ the user’s specific needs and the task at hand. Some examples of this functionality are the ability to point copilot to a word document, and request to create a power point presentation based on the data in the document.

Copilot will also work with tools from the Power Platform and Dynamics 365 products. Copilot for Power Virtual Agents is already in preview.

Copilot enables marketers to create targeted customer experiences and interactions that are informed by data-driven decision making. With access to the natural language data discovery feature in Customer Insights, they can build confidence by validating and discovering customer insights for their marketing strategies. For example, a marketer can ask Copilot how many of their customers fit the profile of currently residing in Washington, DC, who are over the age of 25, who have also attended a promotional event in the last six months.

With just a few clicks, Copilot will present the results of their query, including the number of customers that match the attributes or behaviors, as well as other useful information such as the customer lifetime value, product preferences, or average purchase price.

Copilot in Dynamics 365 Customer Insights removes the barrier of needing to craft queries in SQL to get a deeper understanding of customers, enabling marketers to speed and scale the delivery of hyper-personalized experiences that customers expect.

Copilot in Viva Sales

Automatically generate contextual email replies and meeting summaries with Copilot in Viva Sales, available to Dynamics 365 Sales customers. Copilot in Microsoft Dynamics 365 Sales and Viva Sales helps sellers dramatically reduce the time they spend on clerical tasks. AI helps write email responses to customers and can even create an email summary of a Teams meeting in Outlook. The meeting summary pulls in details from the seller’s CRM such as product and pricing information, as well as insights from the recorded Teams call. With sellers spending as much as 66% of their day checking and responding to emails, this presents a significant business upside to give the seller more time with their customers.

. For example, with Viva Sales, Copilot can learn how to connect to CRM systems of record to pull customer data — like interaction and order histories — into communications. As Copilot learns about new domains and processes, it will be able to perform even more sophisticated tasks and queries.

Copilot in Microsoft Viva Goals simplifies goal setting by guiding leaders through the process of creating objectives and key results (OKRs) as well as simplifying goal management across the organization. Copilot can suggest draft OKR recommendations based on existing Word documents, such as an annual business plan or a product strategy paper. Once created, Copilot saves employees time by summarizing the status of OKRs, identifying blockers, and suggesting next steps. Lastly, Copilot can consolidate existing data to generate more comprehensive check-ins so teams can leverage a breadth of knowledge across different sources of truth.

An entirely new experience is Business Chat that works across he Microsoft 365 apps, and your data — your calendar, emails, chats, documents, meetings and contacts — to do things you’ve never been able to do before. You can give it natural language prompts like “Tell my team how we updated the product strategy,” and it will generate a status update based on the morning’s meetings, emails and chat threads.

You will be able to access Business Chat from Microsoft 365.com, from Bing when you’re signed in with your work account, or from Teams.

Copilot will fundamentally change how people work with AI and how AI works with people. As with any new pattern of work, there’s a learning curve — but those who embrace this new way of working will quickly gain an edge. Copilot is integrated into Microsoft 365 and automatically inherits all your company’s valuable security, compliance, and privacy policies and processes. Two-factor authentication, compliance boundaries, privacy protections, and more make Copilot the AI solution you can trust.

I have only scratched the surface – Teams swept the business world during COVID now Co-Pilot and VIVA integrated across your favourite apps erps and crm systems – we often read about game changing software and paradigm shifts- but this times it’s for real and faster than we realise.

Why now is the time to adopt Power Bi – ask Synergy Software Systems, Dubai

August 19th, 2022

Power BI innovation never stops. For several years in a row now, it is positioned as a leader in the 2021 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms, furthest to the right for completeness of vision and furthest up in the ability to execute within the Leaders’ quadrant.

The gaps are widening with interactive reports, paginated reports, datasets, dataflows, deployment pipelines, scorecards, dashboards, metrics, data alerts, and much more, and recently announced in public preview, self-service datamarts. No wonder, customers are adopting Power BI at an accelerated pace. Boost Office 365 productivity with Power BI integrated into PowerPoint and Microsoft Teams, connect to data anywhere with hundreds of built-in connectors, leverage industry-leading AI, go quickly from insight to action with the Microsoft Power Platform, and provide best-in-class mobile experiences with Power BI Mobile.

Reports can be mobile friendly, they can be paginated, and you can link into Azure Analysis Services.

SharePoint news from Insight 2021

November 9th, 2021

The SharePoint Server Subscription Edition became generally available this week, Customers install it on their own server hardware, but Microsoft leases it via a subscription.

Microsoft documents on SharePoint Server Subscription Edition,  here.

Subscription-Based App Servers
Current SharePoint Server users can now only purchase the latest SharePoint Server products by subscription. There’s no “SharePoint Server 2022” product .

Expect future releases of Exchange Server, Skype for Business Server and Project Server products to be sold by subscription as Microsoft mentioned this shift of its new application server products to a subscription model last year in October

You can upgrade from SharePoint Server 2019 or SharePoint Server 2016 to the SharePoint Server Subscription Edition.

SharePoint Ignite Improvements
SharePoint Admin Center :

  • Ability to rename a SharePoint Online tenant URL name (preview).
  • OneDrive sync reports now support Mac devices.
  • IT pros can manage Teams and channel-connected team sites.
  • Migration Manager now has file scanning for Box online storage moves.
  • SharePoint Server workflows can be migrated to Power Automate directly.

For sensitivity labels are “more granular. It’s possible to use a label that requires multifactor authentication,. Microsoft is also previewing new “Data Access Governance rights” to monitor sharing activities.

SharePoint users are getting faster upload (5x) and download (10x) speeds, , presumably versus the SharePoint Online service. (

SharePoint Online stores 100 petabytes per month of data. Microsoft has more than 200 datacenters across 34 countries for its SharePoint Online service.)

Other new features include:

New SharePoint Site templates – for retail, healthcare, and non-profit

The latest update will bring three new SharePoint site templates to retail customers, non-profits, and healthcare organisations. All allow organisations to better track, manage information, and collaborate.

HRetail: The new retail management and store collaboration templates allow retail employees to manage the store operation more efficiently and foster a better collaboration environment.

Non-profit: The new volunteer centre template will allow organisers to point volunteers to one place to find key information, access learning materials, and connect with other volunteers.

Healthcare: The new healthcare collaboration template provides medical practices and healthcare agencies with a safe, secure way to share information that can help you provide better patient care and reduce operational costs.

Modern SharePoint site-level term store

An updated experience when creating and managing site-level taxonomy terms; which matches the previously updated, central term store in the SharePoint admin centre. This makes it easier to navigate taxonomies and to create and to edit terms when classifying and discovering Syntex and SharePoint content.

Edit images in SharePoint and OneDrive

Rotate, crop (both freeform crop and fixed aspect ratio crop) and flip your images – horizontally and vertically. This update also includes options to adjust the light and colour saturation of your images. Watch an image transform from muted colours and low contrast to richly coloured and stunning. Make those transformations easily with adjustments for brightness, exposure, contrast, highlights, shadows, and colour saturation.

Calendar view in List web part

To build a mini-dashboard for an internal event or project schedule and to represent your list of information as a calendar use the latest SharePoint List web part in Microsoft 365 to display a list from your team or site on a page and to customise it with your own title, view, and even size.

It is a great visual tool for internal communications – especially when things are date-driven.

IFRS16 Asset leasing in Dynamics 365

September 1st, 2021

Asset leasing helps customers feel more confident that they’re following the proper accounting standards for ASC 842 and IFRS 16, reducing the risk of spending extensive time doing offline calculations. Asset leasing will reduce manual errors and save your users time through automatic lease status updates, right of use assets, wholistic monitoring and analytics, and calculations of net present value, lease interest, and future cash payments.

Dynamics 365 Finance > Asset leasing > Lease management

Asset leasing can help you with the following:  

Automates the complex lease calculation of present value and its subsequent processes such as future lease payment, lease liability amortization, right-of-use asset depreciation, and expense schedules.

Automatically classifies the lease as either operating or finance, or as a short-term lease or low-value lease. The lease classification tests include transfer of ownership, purchase option, lease term, present value, and unique asset.

Centralizes the management of lease information, such as important dates, including the commencement and expiration dates, as well as the lease’s transaction currency, payment amounts, and payment frequency.

Helps to generate accounting entries for the initial recognition, and subsequent measurement of the lease liability and right-of-use asset.

Reduces time for complex calculation of lease modification and automatic adjustment transactions.

Provides posting to different layers to accommodate different reporting purposes, such as tax reports that are available in Dynamics 365 Finance.

Complies with the accounting standards to represent leases on a balance sheet using the Balance sheet impact calculator.

Provides audit controls over the integrity of the lease data to ensure that the posted transactions match the calculated amounts of the present value, future payments, and liability amortization.

Provides tools to import from or export to Excel for all lease data using data management.

Includes features that help in preparing asset leasing reports, particularly the preparation of disclosures and notes.

Integrates with company chart of accounts, currencies, fixed assets, vendors, journals, data management, and number sequences.

Asset leasing integrates seamlessly with other components of Dynamics 365 Finance, including Fixed assets, Accounts payable, and General ledger. Integrates with your company chart of accounts, currencies, fixed assets, vendors, journals, data management, and number sequences.

  • Complies with the accounting standards to represent leases in balance sheets using the Balance sheet impact calculator.
  • Provides audit controls over the integrity of the lease data to ensure that the posted transactions match the calculated amounts of the present value, future payments, and liability amortization.
  • Provides tools to import from or export to Excel for all lease data.

If you need to comply with IFRS16 , or need assistance with implementation or support of Dynamics 365 Finance and SCM then contact Synergy Software Systems 009714 3365589.

August 24th, 2021

A bungled data migration of a network drive caused the deletion of 22 terabytes of information from Dallas Police Department police force’s systems – included case files in a murder trial,during a data migration exercise carried out at the end of the 2020-21 financial year

“On August 6, 2021, the Dallas Police Department (DPD) and City of Dallas Information and Technology Services Department (ITS) informed the administration of this Office that in April 2021, the City discovered that multiple terabytes of DPD data had been deleted during a data migration of a DPD network drive,” said a statement [PDF] from the Dallas County prosecutor’s office.

14TB were recovered, presumably from backups, but “approximately 8 Terabytes remain missing and are believed to be unrecoverable.”

The Home Office initially issued a statement saying the data loss was down to a “technical issue”, which had been resolved, There must have been some technical resolution because the Home Office later said it was not a technical issue after all, and in fact a “housekeeping error” with Home Secretary Priti Patel saying: “Home Office engineers continue to work to restore data lost as a result of human error during a routine housekeeping process earlier this week.”

In a letter published by The Guardian, National Police Chiefs’ Council (NPCC) deputy chief constable Naveed Malik, lead for the organisation on the Police National Computer (PNC), said approximately 213,000 offence records, 175,000 arrest records and 15,000 person records had potentially been deleted in error. The DNA database connected to the PNC saw 26,000 records corresponding to 21,710 subjects potentially deleted in error, “including records previously marked for indefinite retention following conviction of serious offences”. The letter also said 30,000 fingerprint records and 600 subject records may have been deleted in error.

The PNC dates back to the 1970s. The current iteration is a Fujitsu BS2000/OSD SE700-30 mainframe based in a Hendon data centre, running Software AG’s natural programming language-using ADABAS database. The UK’s territorial and regional police forces, Serious Fraud Office, Security and Secret Intelligence Services (MI5, MI6), HM Revenue & Customs, and the National Crime Agency all make use of it. They have controlled and 24-hour access from remote terminals and through local police force systems.

These incidents highlight the importance of backups and backup and recovery processes. How often do you test whether you can restore your back ups? Does this still work for restoring older back ups when you upgrade? Has a move to the cloud changed the retention of your back ups, the frequency of upgrades, or the ease or time for restore?

Quickly identify and fix your performance bottleneck

May 4th, 2021

Are you responsible for a busy SQL server, for example, the Finance Department’s systems, documentation management, CRM, BI, or a Web Server; perhaps a busy file and print server, or something else entirely.

Were you responsible for installing the application running the workload for your company? Is the workload business critical, i.e. TOO BIG TO FAIL?

Do users, or even worse, customers, complain about performance?

If you are responsible to keep the workloads running in your organization that would benefit from additional performance, please read on – even if you don’t consider yourself a “Techie”.

Windows and VMs are both factors of high latency that impacts performance.

Variables Affecting the Performance of the Applications

There are many variables that affect the performance of those applications. The slowest, i.e. the most restrictive of these is the “Bottleneck”. Think of water being poured from a bottle. The water can only flow as fast as the neck of the bottle, the ‘slowest’ part of the bottle.

In a computer hardware the bottleneck will almost always fit into one of the following categories:

  • CPU
  • DISK
  • MEMORY
  • NETWORK

With Windows, it is usually very easy to find out which one the bottleneck is in, and here is how to do it (like an IT Engineer):

  • To open Resource Monitor – click the Start menu, and type “resource monitor”, and press Enter. Microsoft includes this as part of the Windows operating system and it is already installed.
  • Notice the graphs in the right-hand pane. When your computer is running at peak load, or users are complaining about performance, which of the graphs are ‘maxing out’? This is a great indicator of where your workload’s bottleneck is to be found.
Resource monitor

What You Can Do to Improve Application Performance

Once you have identified your bottleneck – the slowest part of your ‘compute environment’ then, what can you do to improve it?

The traditional approach to solving computer performance issues is to throw bigger and more powerful hardware at the solution like an extra disk or a new laptop, or putting more RAM into your workstation, or on the more extreme end, buying new servers or expensive storage solutions.

How do you decide when it is appropriate to spend money on new or additional hardware, and when it isn’t. Well the obvious answer is; ‘when you can get the performance that you need’, with the existing hardware infrastructure that you have already bought.

You don’t replace your car, just because it needs a service or tuning?

Let’s take disk speed as an example. Look at the response time column in Resource Monitor. Open the monitor to full screen or large enough to see the data. On the Overview tab, open the Disk Activity section so that you can see the Response Time column.

Do it now on the computer you’re using to read this. (You didn’t close Resource Monitor yet, did you?) This shows the Disk Response Time, or , how long is the storage taking to read and write data? Of course, a slower disk speed = a slower performance, but what is considered a good disk speed or a bad speed?

Scott Lowe, has written a great post that you can read here…TechRepublic: Use Resource Monitor to monitor storage performance that perfectly describes what to expect from faster and slower Disk Response Times:

Response Time (ms). Disk response time in milliseconds. For this metric, a lower number is definitely better; in general, anything less than 10 ms is considered good performance. If you occasionally go beyond 10 ms, you should be okay, but if the system is consistently waiting more than 20 ms for response from the storage, then you may have a problem that needs attention, and it’s likely that users will notice performance degradation. At 50 ms and greater, the problem is serious.”

I hope when you check on your computer, the Disk Response Time is below 20 milliseconds. What about those other workloads that you were thinking about earlier. What’s the Disk Response Times on that busy SQL server, the CRM or BI platform, or those Windows servers that the users complain about?

Your Two Options

When the Disk Response Times are often higher than 20 milliseconds, and you need to improve the application performance, then it’s choice time and there are two main options:

  • Storage workload reduction software like DymaxIO™ fast data (Diskeeper®, SSDkeeper®, and V-locity® are now new DymaxIO fast data software). This tool will reduce Disk Storage Times by allowing much e of the data that your applications need to read, to come from a RAM cache, rather than be read slower disk storage. RAM is much faster than the media in your disk storage.
  • Contact us to trial this. You don’t even need to reboot.
  • If you have tried the DymaxIO software, and you still need faster disk access, then, it’s time to start getting quotations for new hardware. It does make sense though, to take a couple of minutes to install DymaxIO first, to see if that can be avoided. The software solution to remove storage inefficiencies is typically a much more cost-effective solution than having to buy hardware! A software solution to a software problem.

Improve Your Application Performance by Decreasing Disk Latency like an IT Engineer – call us to learn more 0097143365589

Snaplogic iPaaS now even better – ask Synergy Software Systems

April 29th, 2021

We’re excited to announce the ‘February 2021’ release of the SnapLogic Intelligent Integration Platform. In this release, there are a number of new Snap Packs: for Marketo and Hubspot. for Marketing Automation, for Microsoft Teams and Power BI for team communication and analytics rly, and OpenAPI to connect to any OpenAPI compliant endpoints.

There is also support for Azure Synapse analytics to our ELT capability. Platform enhancements include :

  • higher productivity through expanded Universal search,
  • platform notifications to Slack,
  • better reliability through Snaplex level scheduling, and more.

Hassle-free connectivity with NEW Snap Packs

New Snap Packs provide out-of-the-box connectivity to key enterprise endpoints.  For example the new Marketo and Hubspot Snap Packs allow you to connect seamlessly to these marketing automation systems. Easily manage marketing assets/campaigns or leads that enter your marketing funnel. While HubSpot Snap Pack supports CRUD (create, read, update, delete) operations, the Marketo Snap Pack allows you to do bulk operations on leads.

With these Snap Packs, quickly sync your assets and leads data across Marketing, Sales, and other functional areas and easily connect to event/survey applications such as Eventbrite, SurveyMonkey, or to Demand Generation tools such as Google Ads, Linkedin, and Analytics endpoints such as Microsoft Power BI and Tableau.

The  Microsoft Power BI Snap Pack is also new and allows you to connect your Power BI instance to hundreds of data sources to bring your data to life with live dashboards and reports. Visualize your data and share insights across teams or embed these in your app or website. The Snap Pack helps you to post, push datasets, read, and edit so that you can easily query data, create/bind entities, import files, and update entities.

For an organization that has a heavy investment in the Microsoft ecosystem, the next Snap Pack the new Microsoft Teams Snap Pack allows you to easily integrate your Microsoft Teams into your enterprise workflows for customers, employees, and teams. This Snap Pack supports accounts such as OAuth2 User, Application, and Dynamic accounts to adhere to your enterprise security standards. Use it to send messages, perform channel operations, and perform team operations. . 

Another key new Snap Pack with this release is the OpenAPI Snap Pack. Most API endpoints today adhere to the OpenAPI specification version 2 or 3. Leverage this Snap Pack to connect to any API endpoint with the published OpenAPI specification so that users can get all the needed documentation while they build their automated workflows. More efficiently connect to any generic endpoint without the need for specific Snaps.

Improved connectivity with other Snap Pack enhancements

Google Sheets Snap Pack now supports JSON based version 4 of the API rather than XML based version 3

Kafka Snap Pack updates now support reading/writing record headers and timestamps, provide option to choose one output document per batch. The later feature allows systems that don’t natively support streaming data to effectively work with Kafka messages by batching them together.

Amazon Redshift and Amazon SQS Snap Packs provide cross-account IAM support that allows organizations to trust and allocate roles with specific access privileges to specific groups or users.

Pushdown to any cloud data warehouse including Azure Synapse 

Over previous releases, Snaplogic has introduced ELT support for Snowflake, Redshift cloud data warehouses so that you can do both ETL and ELT on a single platform. The ELT support is extended to Azure Synapse with this release. With ELT for Azure Synapse, you can accelerate data loading into Azure Synapse to provide ultimate flexibility to transform data by use of all computing resources across SnapLogic and Azure Synpase, thus reducing TCO and enabling a faster time-to-value. 

With the SnapLogic platform yextract data from SaaS applications and databases with a vast number of Snaps. Once the data is in the staging area in Azure Cloud Storage, visually define data transformations, no need to write SQL. These visual transformations are converted into SQL statements and pushed to Azure Synapse for execution.

New features added to SnapLogic ELT make it easy to discover schema and SQL functions in the target cloud data warehouse. The platform provides suggestions for column names during LOAD, INSERT SELECT or MERGE INTO operations. The platform also provides SQL function suggestions when working with your target cloud data warehouse. To deal with large number of SQL functions various cloud data warehouses support, are grouped into different categories to simplify discovery.

Better Ease of Use and improved resiliency with the Platform Updates

The SnapLogic Intelligent Integration platform continues to evolve to make it easy for integration developers, whether they are technical or non-technical, to build and monitor integrations. 

Universal Search, as the name suggests helps you search everything related to SnapLogic, all from a single search box. With the February release, it now performs pipeline searches in addition to the searches in Community, Configured Snaps and Documentation. This is not just a simple text based search. The Iris AI integration assistant provides more relevant search results across generic content (in community and documentation) and specific content from your org (such as pipelines or configured Snaps that you have access to). T

Figure 1: Universal search now supports pipeline searches

To efficiently monitor your integrations use the platform notifications to Slack. Users then get notified via Slack for any notifications from SnapLogic platform such as Daily API Usage, Snaplex Congestion, CPU usage, user activity, in addition to email notifications. Send notifications either on Slack Channels or directly to users.

Figure 2: Configuring Notifications to Slack

Enable Snaplex levels scheduling for all the scheduled tasks. This update reduces the time difference between the scheduled time of task execution and the actual time of task execution. With this update, your scheduled tasks won’t be affected by network disruption of the control plane helping your reliably deliver data that advances business processes and delivers insights.

10 X Faster Reports on SQL! Run Time from 30 Mins to 3 Mins! Ask Synergy Software Systems

April 27th, 2021

The performance degradation of applications running on Windows, and VMs is getting inherently worse. This includes latency issues, queries or reports timing out, crashes, missed SLAs, back office batch jobs bleeding over into production hours, and the litany of “shadow IT” problems that wreak havoc.

Even after migrating to a brand-new flash array, performance problems return because the root source of the problem still exists. The fact is, 30-40% of performance is being robbed by small, fractured, random I/O being generated due to operating system I/O inefficiencies. This is a software problem that is solved by our software.

DymaxIO™ fast data software will quickly:

  • Increase performance automatically – no tuning required. Simply install and watch performance problems disappear.
  • Optimizes writes so maximum payload is carried with every I/O operation.
  • Speed up I/O intensive applications like MS-SQL/Oracle, CRM, ERP, File Servers, Imaging, Web Servers, Backups, VDI.

Install our software on your most troublesome servers and see 30-50% or more of the noisy, garbage I/O offloaded and performance dramatically improved.

DymaxIO Subscription Licensing -all Condusiv products now rolled into one for fast data.

October 21st, 2020

All of the technologies in V-locity®, Diskeeper®, and SSDkeeper® have been rolled into one new product – DymaxIO™.

New DymaxIO is fast data software. Whether on-premises or in the Cloud, DymaxIO returns more than 40%+ of your hroughput that is being robbed due to I/O inefficiencies of Windows, SQl and virtualisation.

Fix your application slows, freezes, timeouts, slow SQL queries, reduce cloud compute costs, and more, at the source – no new hardware needed.
A software solutlion to a software performance problem.

DymaxIO is sold as an annual subscription which saves you money. Subscriptions are available for client, server, and host systems.

A new DymaxIO site license is also available to conveniently and cost-effectively optimize the performance of all Windows systems.

To improve performance across your systems callus on 009714 3365589

SSD performance degrades over time- prevent this with DymaxIO

September 29th, 2020

Can SSD performance degrade over time and is there a way to prevent this? The answer is YES and YES. the same solution that addresses the inefficiencies of iops in Windows , SQL and VMs can also help you to maintain the performance of your solid state disks.

The reason for this degradation is an undesirable SSD phenomenon called the Write Amplification Factor (WAF), . This is a numerical value that indicates the actual amount of data that was written to an SSD in relation to the amount of data that was requested to be written from the Host (i.e. Windows OS System)

WAF = the data written to the SSD / the data written by the host

For example, an application on the Windows Server system writes out 128kb of data to the SSD, but internally on the SSD, 512kb of data is written on the SSD for this to occur. This will degrade SSDs write performance.

In this example, the WAF = 512kb/128kb = 4 ! This is bad, a 128kb write from the host that resulted in 512kb of internal writes on the SSD

Ideally, you want a WAF = 128KB/128KB = 1

Why does this occur. Unlike HDDs, data cannot be directly overwritten on a disk. On SSDs, data can only be written to erased spaces. When you have a brand new initialized SSD, all of the pages are in a free/erased state, and there is no problem for it to find free/erased spaces to write new data. But as the SSD starts to fill up with data, resulting in erased spaces having to be created that causes the WAF to increase. I can go into more detail on this but will save it for another time. Suffice to say, a higher WAF value means SSD performance degradation.

Do SSDs degrade over time?

The answer is YES but this has to do more with the SSDs filling up over time. Some recommendations on the web advise to keep free space on SSDs anywhere from 10% to 30% to avoid this degradation. With less free space on a highly I/O intensive system, a couple of things occur:

-There are less free spaces to write to, extra overhead may have to occur like block erasures to allow the new updates to occur. This increases the WAF – Not a good thing.
– With less free space, file data may get spread out to different locations on the SSD. For example, in the best case, 10 pages of file data that is being updated are all on the same block.
– When the block needs to be erased to be updated, then just that one block needs to be updated. If those 10 pages are on 10 different blocks, then in the worst case, those 10 blocks have to be erased and re-written – More overhead and a higher WAF.

The result is

➣SSDs are overprovisioned. For example, a 1TB SSD actually contains 1.1TB of data space. This extra space (seen only by the SSD internals) helps to allow the WAF to remain low.
➣SSD Garbage collection and Trim. Both of these processes include freeing/erasing spaces in the background so new writes can occur quickly on these newly erased spaces.

How doies DymaxIO™ help with SSDs Degrading?

DymaxIO has technology to keep the WAF low.

The patented IntelliWrite® technology enforces efficient Sequential Writes to occur rather than smaller Random Writes from the Windows Host. Sequential writes are more likely to place data in the same blocks which can decrease the WAF

Optimization engines keep the free space contiguous when needed on the host logical side. This will help enforce larger sequential writes to occur which decrease the WAF.

There are also a few more benefits of enforcing larger sequential writes.
– Sequential I/Os out-perform Random I/Os on storage, both HDDs and SSDs, so this ensures you are getting the optimal performance from your storage.
– Keeping the WAF low and writes lower on the SSD helps to extend the lifetime of the SSD.

IntelliWrite technology in DymaxIO does both of these functions automatically
– Keep sufficient free space on your SSDs
– Enforce Sequential Writes rather than Random Writes.

Fix at the source. 2X SQL application performance, accelerate Windows throughput 40+%, extend hardware life 2 to 3 years, reduce timeouts, crashes, and more. A software solution to software problems Just install, DymaxIOno code changes, no reboot necessary.

Call Synergy Software Systems 0097143365589