How do I convince my DBA there's a sporadic issue with the SQL Server?
The issue: basically, major slow down... Some queries, generating execution plans, even generating scripts of existing DB objects can sometimes take forever. Even operations that should have no performance issue, like generating the create table script, can sometimes take forever.
The situation - I have a SQL Server database on which I can create tables / views / etc..
The DB is hosted on a SQL Server (MS SQL Server 2016) managed by the company's IT.
I've asked him to look into it, and I believe he's been earnest in checking logs and he says the load on the server at times I noticed massive performance issues showed nothing out of the ordinary. In fact, he said it was all under 5% (very low).
I have the exact same code and queries running in staging and development environments, it's fine there - it's even super speedy relative to the production environment.
I'm at a loss at what could be the issue to be honest. And I don't know where to start.