Viewing 15 posts - 1,261 through 1,275 (of 49,552 total)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2017 at 4:00 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2017 at 3:33 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2017 at 3:05 am
Is it getting blocked by other queries on production?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2017 at 2:54 am
While I know there are mistakes in my documentation that I don't know about, I've...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 2:11 pm
None really.
You have to restart the instance for the ALTER DATABASE to take effect and actually move the files, so whether you do that as a failover and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 2:06 pm
Use TRY ... CATCH blocks, not the old SQL 2000-style error handling.
If that's the only code that you have and you only ever run it once, there will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 1:42 pm
That's not a deadlock at all. That's an uncommitted transaction and SSMS warning you that you should have committed the transaction before closing the window.
To get that, the COMMIT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 12:03 pm
Are you using filestream?
Are you seeing lots of page splits?
Are you seeing these when inserting or updating LOB data types?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 6:47 am
I wouldn't worry about the latter, it's considered a benign wait.
Are you seeing the MEMORY ALLOCATION EXT wait frequently on user sessions? Sessions that are actually running queries...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 6:35 am
Are you getting it significantly? All the time, or just occasionally
https://www.sqlskills.com/help/waits/memory_allocation_ext/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 6:11 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 6:04 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 5:56 am
Grant Fritchey - Wednesday, June 14, 2017 5:43 AMIt's an 8gb server .
My laptop has twice the memory as that production server....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 5:50 am
Backup?
Are you using a VM on Azure, or Azure SQLDB (the PaaS offering)?
The DMVs are not included in backups, they're dynamic views, views into the server's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 5:38 am
Viewing 15 posts - 1,261 through 1,275 (of 49,552 total)