Dealing with Network Latency Issues and the impact on SQL Server Performance
IDERA sponsored on-demand webinar
SQL Server is used for both small and large datasets and as the data grows performance issues start to surface. SQL can have issues with memory, disk, processor and network and these issues can be resolved with new, faster or more hardware along with tuning your SQL Server queries, but the issue of moving data across the network and limited bandwidth is a much harder issue to resolve.
In this webcast, Dr. Dallas Snider will look at some of the heavy data users such as replication, data imports and exports, report queries and other large queries that slow down due to network bottlenecks. He will discuss some of the options and techniques that can be used to reduce the amount of data that is sent over the network to help improve performance and create a better user experience. In addition, we will take a look at a new network accelerator tool for SQL Server that can further improve performance across the network.
Some of things we will cover include:
- How to approach network latency issues
- Query options in SQL Server Reporting Services
- Performance considerations for SQL Server Analysis Services
- Network issues in SQL Server Integration Services
- Troubleshooting techniques for network latency issues
Speaker - Dallas Snider
Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida. He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received a B.A. in Physics from Hendrix College. Before joining UWF, he worked as a data warehouse developer for Northrop Grumman Information Systems and prior to that as a database application developer for Acxiom and Euronet. Dr. Sniderís teaching and research interests include data mining, data warehousing, information visualization, and software development.
To access materials please fill out the form below.