Viewing 15 posts - 45,631 through 45,645 (of 49,552 total)
Just bear in mind that the entriesd in the query stats dmv are transient and are removed when the plan is discarded from cache.
It cannot be guaranteed that everything...
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 16, 2008 at 11:30 am
Pleasure.
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 16, 2008 at 11:11 am
You can, but beware if you have more than a couple hundred rows. That kind of correlated subquery/triangular join performs really, really badly on larger row counts.
Maybe a temp table...
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 16, 2008 at 10:56 am
Yes, it will have an effect. How much of one depends not only on the counters but on the frequency that you are logging the events.
I would suggest you try...
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 16, 2008 at 10:39 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic535347-65-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 16, 2008 at 10:37 am
Books online states
The number of read operations on the logical disk that are performed by the server on behalf of the event. These read operations include all reads from...
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 16, 2008 at 10:36 am
I don't have an answer to your cursor question, but maybe a solution that eliminates the cursor would be acceptable.
First a check, are you using SQL 2005? (I assume so,...
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 16, 2008 at 10:30 am
It does normally work out that way, though I have seen cases (on a large table on a server with multiple procs) where the order could come back in different...
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 16, 2008 at 9:20 am
In my experience, if you can start SQL, you're fine.
Steve: System resource contains the definitions of all of the system views, DMVs, Information schema views, all of the sp_ procs...
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 16, 2008 at 9:12 am
Jack Corbett (7/16/2008)
I obviously need to read a lot more.Was a similar query available pre-2005?
No. In 2000 finding the cause of log filling was more trial and error....
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 16, 2008 at 9:04 am
To find the cause of the log filling up, run
SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases
The log_reuse_wait_desc will tell you what is preventing the space in the log file from been...
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 16, 2008 at 8:54 am
You said "It's not in the same order" Do you mean when retrieving?
Tables are considered unordered in SQL. Unless you specify an ORDER BY in a select, there are 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
July 16, 2008 at 8:51 am
Straight from T-SQL, you can't. This is one of the valid reasons to use CLR procs.
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 16, 2008 at 8:45 am
Do you have the transaction log backups from the time of the last full 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
July 16, 2008 at 8:35 am
Do you need to be able to restore that database to the point of failure (should a failure occur) or is it acceptable to restore to the last full 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
July 16, 2008 at 8:34 am
Viewing 15 posts - 45,631 through 45,645 (of 49,552 total)