Viewing 15 posts - 29,596 through 29,610 (of 49,552 total)
Ninja's_RGR'us (11/1/2010)
Plan cache seems the way to go. I couldn't find an event in the perf category with the info I wanted.
Bear in mind that you won't find actual...
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
November 1, 2010 at 11:46 pm
The log is 93% full. Hence there is no way that you are going to be able to shrink it as it currently stands. You need to figure out what...
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
November 1, 2010 at 11:40 pm
There is a reason why it is recommended to schema (owner on 2000) qualify table names. Explicitly naming it dbo.routes would not cause a problem.
This shouldn't cause a problem...
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
November 1, 2010 at 2:12 pm
Optimisation level you should be able to pull out of the plan cache, though the xquery necessary won't be pretty. Probably best to dump the cache to a table, index...
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
November 1, 2010 at 1:42 pm
Michael L John (11/1/2010)
SELECT nameFROM master..sysdatabases
sysdatabases is deprecated, should not be used in new development and will be removed from a future version of the product.
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
November 1, 2010 at 11:56 am
Huh? This thread is 3 years old. What are you asking for?
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
November 1, 2010 at 11:50 am
Alvin Ramard (11/1/2010)
Gail, now that you have the extra bandwidth, you should be able to do the next 20k in half the time, right?
Unfortunately they didn't double my...
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
November 1, 2010 at 11:49 am
Bear in mind that the definition of an index is not the same as the definition (in term of page type) of an Index page
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
November 1, 2010 at 11:48 am
Simon_L (11/1/2010)
I've added the caveat that "file_id = 2" and will have a further...
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
November 1, 2010 at 11:39 am
Ok, few comments...
Unless you have cases of DBs with more than one log, forget the log file name and just use the fileID. It will be 2 for the 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
November 1, 2010 at 10:05 am
Simon_L (11/1/2010)
Trying to get a create a nightly job to srink the transaction log for all dbs on a server.
Why? Unless this is a dev/test server, this is a really,...
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
November 1, 2010 at 9:52 am
I doubt these kinds of internals are documented anywhere. After all, we're using undocumented features.
Definition of index depends who you ask and where you look. What's your context?
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
November 1, 2010 at 9:50 am
Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Those execution costs are estimates. There are lots of things that would make them wrong, bad statistics being one...
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
November 1, 2010 at 9:27 am
David Lester (11/1/2010)
Except, they always under scope hardware. 2 Gb ram, 2 CPU for a lower midsized warehouse, and that is our most powerful server (VM on top of that.)
No...
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
November 1, 2010 at 8:38 am
Thanks all.
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
November 1, 2010 at 8:26 am
Viewing 15 posts - 29,596 through 29,610 (of 49,552 total)