SQL Server Performance

SQL Server Performance

I have developed an application that processes about 40,000 records every time it runs. I am using ADO 2.1 and each record is returning about 100 columns of data, and then its being updated. If the SQL Server is located on the same machine as the program it runs in about 1 hour. If the SQL Server is located in another computer it runs in about 4 hours. Both SQL Servers are comparable in speed and memory, both have 100mps Nics, both on the same network.

My question is, is this normal behavior for a SQL Server or do I have some kind of networking issues or SQL Setup problems. I suspect it is just running slower because of the amount of data being transferred over the wire.

It would seem that the network bandwidth would be the biggest limiting factor here. The only way to know what’s normal is to measure it and compare measures over time. Perfmon is the first place to start, then to the network admin to find out if they can shed any light on what impacts performance.

You can also do the math to figure out the size of the update vs the width of the pipe, and therefore figure out how long the update should take.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes