Viewing 15 posts - 36,811 through 36,825 (of 49,552 total)
rudy komacsar (8/26/2009)
hmmm ... could it be that there is a transaction log backup that runs DBCC ?
It's not running CheckDB. It's saying when CheckDB last ran successfully.
08/05/2009 06:41:00,spid58,Unknown,CHECKDB...
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
August 26, 2009 at 8:49 am
Luke L (8/26/2009)
GilaMonster (8/26/2009)
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
August 26, 2009 at 8:37 am
Yay. ISP down, again. This time their main basestation is down, affecting every single one of their customers. It's been down since around 3am this morning, eta until repaired, unknown.
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
August 26, 2009 at 8:14 am
Duplicate post. No replies to this thread please.
Direct replies to http://www.sqlservercentral.com/Forums/Topic777331-146-1.aspx
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
August 26, 2009 at 7:59 am
While inserts and updates can cause fragmentation, deletes cannot. Inserts may, or may not cause fragmentation, depending on what the index key is. Updates may cause fragmentation or may not,...
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
August 26, 2009 at 7:58 am
Rob Goddard (8/26/2009)
Generally the uncompressed backup size will be equivalent to the size of the used portion of the data and log files.
Used portion of data, yes. Used portion...
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
August 26, 2009 at 7:56 am
kramaswamy (8/26/2009)
Yeah, the execution plans were all identical. So, you're saying that the read-ahead reads are something that could change even if I were to re-run the exact same query?
Correct....
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
August 26, 2009 at 7:51 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic777318-146-1.aspx
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
August 26, 2009 at 7:47 am
http://www.google.com/search?q=%22office+2010%22+beta
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
August 26, 2009 at 7:44 am
Dave Ballantyne (8/26/2009)
dont attempt to compare relative performance of queries with doing it.
Well....... depends.
Personally, I never use it when comparing 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
August 26, 2009 at 7:42 am
Need execution plans to say anything useful here.
What's the output of STATISTICS IO and STATISTICS TIME for the query with the unique index and the one without?
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
August 26, 2009 at 7:40 am
It's the logical IOs that you need to compare to see which does the most work. Read-ahead reads means that some of the required pages were not in memory (maybe...
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
August 26, 2009 at 7:36 am
The backup is the size of the data in the database, not the size the database was at the time of backup. To restore it, you need free space to...
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
August 26, 2009 at 7:32 am
Plus correcting the bad advice helps all those numerous people who run across the thread via google but never post. Otherwise they're maybe going to take that bad advice as...
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
August 26, 2009 at 7:28 am
Edit: double post
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
August 26, 2009 at 1:27 am
Viewing 15 posts - 36,811 through 36,825 (of 49,552 total)