Viewing 15 posts - 9,526 through 9,540 (of 49,552 total)
S_Kumar_S (3/26/2014)
This doesn't seem to be true. You can partition on a nonclustered column even when u already have data and a clustered index on other column.
But that's not partitioning...
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
March 26, 2014 at 9:12 am
Just to be sure to be sure to be sure š (because it would be a cause of this), what does RESTORE HEADERONLY return on one of the backups showing...
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
March 26, 2014 at 9:08 am
You're absolutely sure there aren't somehow multiple backups appended in the same file? (since you're using noinit on the backup)
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
March 26, 2014 at 8:59 am
What are the exact versions of the two servers?
SELECT @@Version
Any traceflags enabled on either server?
There's only one backup in that file? Not multiple appended somehow?
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
March 26, 2014 at 8:49 am
Go back until you find an error log that has the startup details in it, that one is a re-initialised log.
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
March 26, 2014 at 8:35 am
Why do you want to do that though?
SQL manages its own memory well. You don't need to 'clean' memory out. All you're doling by running those commands is making SQL...
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
March 26, 2014 at 8:34 am
Hmmm... that's odd.
Should created the DB exactly as it was at the time of the backup. Nothing else going on? No reverts from snapshot? No data obfuscations being run?
Can 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
March 26, 2014 at 8:32 am
You've got traceflag 1222 turned on.
You can turn it off with DBCC TRACEOFF, but depending on how it was enabled it may come back.
Can you post the first 15...
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
March 26, 2014 at 8:27 am
WebTechie38 (3/26/2014)
The reason I proposed my question is why am I getting this in the errorlog when the database is in recovery mode is simple.
The message has nothing to do...
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
March 26, 2014 at 8:13 am
You said the production DB has initial size of 15GB, what's the actual size of the data file on disk?
Edit: Native backups? What's the backup command? What's the restore command?
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
March 26, 2014 at 8:06 am
Can you post an example?
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
March 26, 2014 at 8:04 am
jasona.work (3/26/2014)
Basically the equivalent of yanking the power cord, so that may have caused this originally.
Unlikely. SQL is quite capable of handling a hard shutdown. Something has gone...
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
March 26, 2014 at 6:44 am
jacobmellado (3/26/2014)
Replace in the query:WHERE (h.timestamp BETWEEN GETDATE() - 14 AND GETDATE())
The planner does a table scan with that "Where".
There's nothing in that predicate which will force...
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
March 26, 2014 at 6:29 am
jjturner (3/26/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
March 26, 2014 at 6:16 am
As general good practice, you should update all stats (with fullscan preferably) and run CheckDB after any version upgrade. Absolutely necessary, no. Avoids possible later unpleasant surprises, yes.
As for the...
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
March 26, 2014 at 6:08 am
Viewing 15 posts - 9,526 through 9,540 (of 49,552 total)