September 23, 2025 at 12:10 pm
Experts, I am hoping to get some help and feedback. I have a server with 5 instances on it. Out of 256 GB, I have allocated 36GB to this instance. This specific instance has been up and running for over a year now without issues. This instance also has 6 DBs. Yesterday I noticed when I was expanding the table, I started getting timeouts. Even when I logged into the server, I ran into the same issue. I have tried restarting the instance, rebuilding all fragmented indexes, stats are up to date for tables, yet still the same issue. It happens for all 6 DBs. Any feedback is highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 23, 2025 at 1:13 pm
Are you talking about SQL Server Management Studio? What version? Are you running it locally, or on the server?
What are the stats for disk & network throughput & latency when this is happening vs when it isn't? Has anyone done diagnostics on the network & disks/SAN?
Is this on a VM? If so, have VM settings changed?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply