Archive for the ‘HR and Payroll’ category

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.

What is the true cost of software development?

January 9th, 2021

There ahs been much talk of both devops and citizen developers.
While these new paradigms are welcome and bring many benefits that does not mean that they replace other proven systems of software development.

There are reason why some consultancies quote significantly lower times to develop than other- usually tis lack of knowledge/awareness of what needs to be considered or they deliberately cut corners in areas like security, validation, documentation, testing, and so on.

If that sounds harsh then take a look a this recent post:
A report published last week by the Consortium for Information & Software Quality (CISQ) estimates poor software quality collectively cost companies in the U.S. an estimated $2.08 trillion in 2020.

Endpoint security against cybercrime – 7 key questions

December 17th, 2020

7 Vital Questions to Ask

Endpoint security has never been more important, more complex—or more challenging— than it is today. Given the multitude of solutions and of vendors , it is very difficult to sort through all of the competing claims to find what’s truly effective.

1. Will this solution run on all the devices in my environment?
2. How long will deployment take?
3. What will the members of my team need to know or learn in order to work with this platform
4. What types of preventative controls are in place?
5.From where does the vendor get its threat intelligence?
6. How does this solution integrate with incident response workflows? 7 Is 24×7 professional support available from the vendor?
7. Can this solution be integrated with other security services, products, or platforms from the same vendor to reduce costs and complexity?

Why Comodo?- Zero Percent Infection and Breaches for Customers

Comodo offers the only cybersecurity that stops undetectable threats.
Cloud-native cybersecurity with auto-containment stops ro-day threats that AI, ML, & other technologies miss.


Historical s scores and statistics from millions of endpoints on thousands of different networks of enterprise customers. It shows zero percent infection and breaches.

With Comodo you can “Protect without Detection.” The cloud-native framework delivers you zero day protection against undetectable threats while defending your endpoints from known threat signatures. Automatic signature updates simplifies deployment across your entire environment to lower operational costs

Contact us about Advanced Endpoint Protection 0097143365589

Power Bi- October Server update, discounted Synergy training, and end of support for PBi on Windows 7

November 6th, 2020

After 10 years, support for Windows 7 ended on January 14, 2020. In line with this, Microsoft will stop support for Power BI Desktop on Windows 7 on Jan 31st 2021. After that, Power BI Desktop will only be supported on Windows 8 or later version.

The January 2021 release of Power BI Desktop Optimized for Report Server will be supported in accordance with the Modern Lifecycle Policy i.e. supported until the next release (currently scheduled for May 2021), after which it will only receive security updates until January 2022, after which support will stop.

As always there were many enhancements to Power BI Report Server in the latest monthly update (October 2020)

Reporting

Modern ribbon
Canvas watermarks
Total labels for stacked visuals
Added general visual option to maintain layer order
Gradient legend
Relative time filter
Slicer improvements
New options for expand/collapse icons
Icons now scale with font size
Ability to customize indentation for child items
Ability to further customize slicer header text
Mobile authoring enhancements
New phone emulator
Updated visualization pane
Support for overlaid visuals
Bookmark available in the Mobile layout view
Turn off gridlines and snap to grid
Visualizations

Line chart dot formatting options
Modeling

Enhanced Dataset Metadata
Performance improvements to IF and SWITCH functions
Support for Excel financial functions
Model view enabled for live connect
Updates to Model view
Data preparation

Automatic Table Detection from Excel files
Automatic Table Detection from JSON files
Global option to disable automatic type detection
Other

Export data source to PBIDS in Power BI Desktop
Desktop splash screen dismiss

To learn more about Power BI there is still time to join our discounted webinar introduction course on 14th November – $100

contact us for details: 0097143365589

Dynamics 365 Finance and SCM upgrade and migration offer from Synergy Software Systems

November 4th, 2020

Over 60 companies tuned into our Webinar with Microsoft last week about the benefits of Dynamics 365 cloud and the upgrade or migration journey.
Note that the special subscription offer incentive, and free uggrade assessments are only available till year end, for a limited number of applicants and first come first served basis . There were also additional discounts offered by Synergy Software Systems till end November 2020.

Some of the reasons for upgrade include:

As of October 2021, Microsoft will no longer support Dynamics AX 2012 R3. That’s not so far away, and now is the time for remaining AX 2009 and 2012 users to move to a new ERP (Enterprise Resource Planning) solution. Such a project will seem daunting, but Microsoft Dynamics 365 Supply Chain & Finance Management will be your last and best upgrade.

An immediate reason Dynamics AX users who have a current Microsoft Dynamics annual enhancement plan to choose Microsoft Dynamics 365 at this time is that can currently receive an intial discount on the Dynamics 365 cloud subscription.

Contact us today to learn more. Keep reading to find out why we think you’ll love Microsoft Dynamics 365.

Advantages of the Microsoft Cloud
When you move from on-premise Dynamics AX to the Dynamics 365, its more than an update of patches or even an upgrade of features. It’s a paradigm shift to compete in the modern digital economy. Dynamics Ax 2was always very versatile and could be customised to meet your specific needs. However that flexibility came at the cost of upgrades to a later version. There might be statutory changes such as introduction of Vat or Revenue recognition, or patches need to fight cybercrime, or business expansion that outgrow existing features and hardware. However the significant challenges, of upgrade constrained the business from making timely ‘agile’ changes.

Additional complexity arose to update integrations, ISV modules and specialist reports, and integrations. With Dynamics 365 Finance & Supply Chain
Management on the Microsoft Cloud, – you will continuously update. The updates are automatic, performed in the background, immediately available, and accommodate your customizations and integrations. You’ll be able to lower your ERP costs, while always benefiting from the latest innovations Microsoft has to offer.

Apps in the Microsoft app store will deploy rapidly without worry about code conflict.

Seamless remote connectivity
Cloud-based solutions such as Dynamics 365 Finance & Supply Chain Management allow out-of-the-box mobile access and anytime, anywhere connectivity. Empower your teams to do their jobs even while working remotely. Give them access to the information and processes they need, whether working from home, on the road, or in the field. Seamless operations provide increased user and customer satisfaction, and increase efficiency.

Built-in disaster recovery
The pandemic and recent natural disasters have shown us that calamity can strike without warning and affect any business. Locating your information and processes in Microsoft’s secure Cloud gives you high-performance, remote access to all your ERP data and processes.
It also guarantees built-in disaster recovery for your organization. You’ll be able to be up and running even if you can’t get to the office. Your information will be secure from both physical disasters and cyberattacks.

Easier integrations
Dynamics 365 Finance & Supply Chain Management is built on a Common Data Service, which connects, ERP, Power Platform (including Power BI) and all the other Microsoft business productivity tools such as Microsoft 365. That enables all of those programs to work together seamlessly. Send and receive data, build workflows, automate processes, and create custom functionality. Your teams will be connected using processes with which they are familiar.

Lower IT costs
A cloud-based solution eliminates the expense of owning and maintain on-premises hardware.
– Hidden but significant savings Include” SQL licenses and support, Windows Server licences, Anti malware software for servers, back up software.
– Save on server room costs for space, electricity, and IT resources.
– No additional BREP charge,

Enhanced performance
The Microsoft Cloud guarantees high performance and ongoing improvements.
Your environment is primarily managed and maintained by Microsoft.
You will never again have the expense of upgrading servers, buying extra data storage, and paying for external hosting. All that will be covered as part of your Dynamics 365 subscription.

Stronger Security
Microsoft’s cloud platform has unparalleled security to safeguard your data.
Dynamics 365 Finance & Supply Chain Management has built-in, role-based security features such as Segregation of Duties (SODs).
Count on Dynamics 365 Finance & Supply Chain Management to support your compliance efforts and meet all your security requirements.

Innovations
Such as AI, virtual agents, connected field service, and more
Advanced tools such as machine learning, artificial intelligence, virtual agents, and connected field service were once out of reach for mid-sized company. Now with Dynamics 365 Finance & Supply Chain Management, you too can leverage the latest technology advancements to unlock new opportunities and gain a competitive edge

Contact us on 0097143365589

Agile business with Microsoft Dynamics 365 Finance and SCMO Webinar with Synergy, Redington & Microsoft.

October 22nd, 2020

Agile business and digital transformation with Microsoft Dynamics 365 Finance and SCM
Webinar with spears from Synergy Software Systems, Redington and Microsoft.

Also features a local case study for a leading UAE real estate group.
Date and Time: UAE – 28th October 2020 | 10:00am -11:30

For existing Dynamics customers looking to upgrade there will be a special offer announced by Redington and Synergy.

Please register on the link :


If you are unable to attend this session and would like to know more about Dynamics 365 then call us on 00971 4 3365589.

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