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?
September 23, 2025 at 1:53 pm
Did you enable Instant File Initialisation for the service account ? ( on all nodes ? )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 23, 2025 at 2:52 pm
"Expanding the table"
Do you mean in SSMS, in object explorer when trying to expand the table to get the columns/indexes etc
If so what timeout did you actually get?
Was it the usual lock time out?
Can you post a screenshot of the timeout errors you're receiving?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply