December 9, 2014 at 9:02 am
Hi,
I have a strange problem. We had a SQL Instance with one big database on a single host. Now we migrated the database to a Microsoft SQL Cluster. On this node is running only this instance.
When I make a query on the studio what reads the top 4 millions of a table i need about 34 seconds. The same database on the old server needs only 25 seconds.
The old and the new server are on the same vmware infrastructure. But the new server has SSD disks, more Memory and more CPU. So I don't unterstand why the new needs more time.
I saw that when I start the query, on my NIC is more traffic. Could the Cluster be the performance issue?
Thanks,
Werner
December 9, 2014 at 9:23 am
Werner
In order to eliminate the NIC as the cause of the reduced performance, select your query results into a temp table instead of having them returned to the caller. That way, you take out the cost of sending the results across the network.
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply