Viewing 15 posts - 10,186 through 10,200 (of 49,552 total)
Backups have nothing to do with index fragmentation. Backups don't care about fragmentation, they don't try to decipher any of the pages. All a backup does is copy data from...
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
January 29, 2014 at 10:27 am
Is the hardware identical?
Are the server settings identical?
Is the data identical?
Are statistics up to date on both servers?
No to any of those could be the reason for the difference.
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
January 29, 2014 at 10:26 am
Either the backup was damaged in the copy and hadn't been taken WITH CHECKSUM or the IO subsystem corrupted the database during/after the restore.
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
January 29, 2014 at 10:25 am
Probably not. Got any backups?
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
January 29, 2014 at 10:22 am
Minnu (1/29/2014)
and the fule "Unify_snapshot.ss" size is showing 4GB.
Where is it showing 4GB? What are you checking, looking at or running to get the size of the file?
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
January 29, 2014 at 10:18 am
PearlJammer1 (1/29/2014)
If these jobs where to 'overlap' each other, could that be the cause of the problem?
No.
Check that it's scheduled, check that the settings are correct, check that it's actually...
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
January 29, 2014 at 7:33 am
A snapshot size cannot be larger than the database it's a snapshot of. Hence why I asked how you're checking size and what values you're looking at where.
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
January 29, 2014 at 7:32 am
Ed Wagner (1/29/2014)
GilaMonster (1/29/2014)
Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously unpleasant.
That sounds seriously unpleasant - that'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
January 29, 2014 at 7:10 am
How are you determining 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
January 29, 2014 at 7:09 am
Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously unpleasant.
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
January 29, 2014 at 6:38 am
sivaramakrishnan G (1/29/2014)
I am Getting Keylookup in Query on Execution Plan.How to avoid this.Due to this when ever i have use this take Query Plan showing Key lookup.
Why do you...
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
January 29, 2014 at 6:35 am
jsayerweb (1/29/2014)
Fully tested... Again sorry 🙂
Msg 8106, Level 16, State 1, Line 5
Table 'ChildReferrals' does not have the identity property. Cannot perform SET operation.
Msg 8106, Level 16, State 1, Line...
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
January 29, 2014 at 6:32 am
philosophaie (1/29/2014)
Is there something wrong with:CREATE PROCEDURE [IncMaxallcount] (@Latin INT) AS
No. The error is, as the error message said, "Incorrect syntax near the keyword 'CONVERT'.", not near the keyword PROCEDURE
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
January 29, 2014 at 5:13 am
Have you opened up the job and looked at exactly what it does?
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
January 29, 2014 at 5:06 am
Have you tried the code?
If so, does it do what you expect?
If not, what does it not do (or what error does it throw)?
Edit: Duplicate thread, please rather continue at...
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
January 29, 2014 at 4:06 am
Viewing 15 posts - 10,186 through 10,200 (of 49,552 total)