Viewing 15 posts - 37,651 through 37,665 (of 49,552 total)
Please query sys.databases and see what the value of log_reuse_wait_descr is for that database. Also run DBCC SQLPERF(LogSpace) and post the results here.
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
July 14, 2009 at 12:35 pm
I thought that anyway.
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
July 14, 2009 at 12:34 pm
Don't use the remove unused space option. Go into the maintenance plan designer and remove that task.
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
July 14, 2009 at 12:34 pm
Grant Fritchey (7/14/2009)
No kaboom.
No boom today. Boom tomorrow. There's always a boom tomorrow.
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
July 14, 2009 at 12:25 pm
Sherri Barkley (7/14/2009)
When I run 'select * from sysobjects where id in (540225842, 540357684)' it returns no records. The same is true if I 'select object_name(540357684)' and 'select object_name(540225842)'.
In...
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
July 14, 2009 at 11:57 am
Don't run the 'remove unused space' task. If you run that after rebuilding indexes, it'll result in worse fragmentation than before the rebuild. No reason to shrink a 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
July 14, 2009 at 11:52 am
Jeff Moden (7/14/2009)
Jack Corbett (7/14/2009)
Was Jeff referring to the Order By in the ROW_NUMBER() function?Yes.
Ok, misunderstood you earlier. Are you suggesting adding a second temp table, one to store 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
July 14, 2009 at 11:38 am
Jeff Moden (7/14/2009)
Building the clustered index afterwards does cut down on page splits if the inserts are in no particular order.
But on a single statement insert the rows...
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
July 14, 2009 at 11:25 am
Krasavita (7/14/2009)
I didn't find any information about Torn Page Protection
http://msdn.microsoft.com/en-us/library/aa933082(SQL.80).aspx
I need to know why my db is set to true in status of sysdatabases and why my other db 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
July 14, 2009 at 11:17 am
If you're having this many performance problems with a procedure, I would suggest you consider getting a specialist in to help you, especially if you're not good at tuning. They...
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
July 14, 2009 at 10:54 am
That's only if a query is waiting for memory. Further quoting from Books Online.
In Microsoft SQL Server, memory-intensive queries (such as those involving sorting and hashing) are queued when there...
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
July 14, 2009 at 10:51 am
Mel Harbour (7/14/2009)
Chris,When I tried both options, there wasn't actually much difference in the performance of the two.
Thing it, it may give us the option to tweak indexes better. 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
July 14, 2009 at 10:47 am
Christopher Stobbs (7/14/2009)
but creating the clustered Index on #TopScores after the actual insert?Would this help at all?
If the cluster goes on after the insert then first SQL has to insert...
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
July 14, 2009 at 10:23 am
I personally would not recommend a repair on MSDB.
http://www.sqlskills.com/BLOGS/PAUL/post/Is-running-repair-on-msdb-safe.aspx
If you've got a clean backup, restore from it. Before you do so, script out all your jobs and alerts. 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
July 14, 2009 at 10:17 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic752826-338-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
July 14, 2009 at 10:14 am
Viewing 15 posts - 37,651 through 37,665 (of 49,552 total)