Viewing 15 posts - 7,156 through 7,170 (of 49,552 total)
Could you perhaps be a little more specific?
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
November 30, 2014 at 7:18 am
Restore from backup.
And, just maybe, consider getting an OS and SQL version that's slightly more modern?
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
November 30, 2014 at 7:17 am
No such version as Windows 2007...
The size limit in SQL Express for all versions 2008 R2 and above is 10GB. If you need a larger DB than that, you need...
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
November 30, 2014 at 7:15 am
Replace the secondary or break the AG and re-setup once the secondary is available again. Don't think AGs added any other options.
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
November 30, 2014 at 7:14 am
Is the table a heap?
Are you shrinking the database after the rebuild?
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
November 28, 2014 at 7:37 am
Yes, normal and documented. You need to run sp_refreshview on both. Or stop using SELECT *
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
November 28, 2014 at 7:21 am
Add three files to TempDB, make sure they're all the same size. If you still see the latch waits after that, add another 4 files.
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
November 28, 2014 at 6:41 am
Are you seeing allocation contention (PAGELATCH_UP waits on 2:1:1, 2:1:2 and/or 2:1:3)? Or IO contention (slow IOs in TempDB, PageIOLatch waits in database 2?
What edition of SQL is this?
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
November 28, 2014 at 6:28 am
Well, without seeing the script, the table and being able to query the data, I can't say for sure, but ideally yes.
Before you do so, make sure that there is...
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
November 28, 2014 at 6:10 am
You will always get a lock on the table. It should be short-lived. Make sure that your split isn't forcing data to move from one partition to another, as that...
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
November 28, 2014 at 6:04 am
PearlJammer1 (11/28/2014)
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
November 28, 2014 at 5:19 am
The Hidden Online schedulers are not for query processing. They're for internal stuff or reserved for the DAC or other stuff like that.
What edition of SQL is that?
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
November 28, 2014 at 5:19 am
It's not something to get around. It's how log backups work. When you implement log shipping, it must replace any current log backup job. Otherwise neither the log shipping nor...
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
November 28, 2014 at 4:26 am
If you implement log shipping, those MUST be the only log backups running against that database
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
November 28, 2014 at 4:17 am
Add more disk space or delete data.
Or move some of the data files to other drives if there are any.
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
November 28, 2014 at 3:11 am
Viewing 15 posts - 7,156 through 7,170 (of 49,552 total)