Viewing 15 posts - 11,326 through 11,340 (of 49,552 total)
SQL Show (10/11/2013)
A high unusual metric of check point pages /sec may indicate your database need more memory since free pages in memory is required at high rate.
No, because running...
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
October 11, 2013 at 4:32 am
Correct, checkpoint writes dirty pages to disk to reduce the time required for database recovery should SQL restart unexpectedly.
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
October 11, 2013 at 2:36 am
Is the service started?
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
October 11, 2013 at 2:33 am
Don't use Task Manager to check SQL's memory usage, it shows incorrect values.
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
October 11, 2013 at 2:32 am
How are you identifying that the session 54 (which is your current session that you're running the sp_who from) is locking resources and preventing updates?
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
October 11, 2013 at 2:30 am
SELECT CHECKSUM(*) FROM StagingTable
Collisions are possible, so you'll have to do a column-by-column check over any matches, but should be faster. The main table can have a computed column with...
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
October 10, 2013 at 4:53 pm
A backup is an extent-by-extent copy of the database. It cannot miss objects or take old versions of objects. What is in a backup is exactly what was in 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
October 10, 2013 at 2:14 pm
logicinside22 (10/10/2013)
Its Overwritting with INIT and NOFORMAT Option.Restore Headeronly showing most current backup file which todays date..
That's because INIT deletes old backups from the file before starting the new...
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
October 10, 2013 at 2:10 pm
You won't be able to do it in one go. You'll need to restore the database to SQL 2000 or 2005 first, then back it up and restore to 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
October 10, 2013 at 2:08 pm
Was the backup overwriting the older backups in the file every night or appending the backup to the file?
Restore headeronly should show you what backups are in the file.
If there'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
October 10, 2013 at 1:01 pm
If the object IDs haven't changed between SQL 2005 and SQL 2008, the system procedure is sp_MSenumchangesdirect (not that it helps much)
Let's rather focus on the two objects in 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
October 10, 2013 at 8:11 am
Eugh, traceflag 1204. I would strongly suggest you turn that off and put 1222 on in its place. Much more information...
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
October 10, 2013 at 8:07 am
Jason Selburg (10/10/2013)
GilaMonster (10/10/2013)
Err.. where?Ok, what are you asking? Where what? 🙂
You said
in the meantime here is the limited information from the SQL Error Log.
but I don't see anything...
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
October 10, 2013 at 7:35 am
I've often found that performance improvements attributed to index rebuilds are due rather to the stats updates that happen at the same time. I have on a number of occasions...
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
October 10, 2013 at 7:33 am
Brandie Tarvin (10/10/2013)
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
October 10, 2013 at 7:18 am
Viewing 15 posts - 11,326 through 11,340 (of 49,552 total)