Viewing 15 posts - 26,836 through 26,850 (of 49,552 total)
Don't understand the question.
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
April 6, 2011 at 4:23 am
- Win. (4/6/2011)
BTWI have disconnected the Mirroring.
That's going to make matters worse.
The mirroring log reuse reason means that the mirroring is not keeping up with the speed of transactions...
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
April 6, 2011 at 4:22 am
- Win. (4/6/2011)
Its a Mirrored DB, active status with 534 gigs of size and 274 gigs of...
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
April 6, 2011 at 3:59 am
crazy4sql (4/6/2011)
because I beleive the table and its stats are out dated.
Maybe, maybe not, but that has nothing to do with and no effect whatsoever on the index usage DMV....
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
April 6, 2011 at 3:57 am
- Win. (4/6/2011)
Sorry Gail..Am looking into now.
Let me know if I can have any suggestions.
The article's full of suggestions (I know, I wrote it)
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
April 6, 2011 at 3:48 am
crazy4sql (4/6/2011)
Can you update the stats for the table and then run the index_usage?
Why?
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
April 6, 2011 at 3:48 am
I know this sounds silly, but can you run the following?
SELECT schema_name(schema_id), name as TableName, object_id FROM sys.objects where name = <name of the table in question>
Is there only...
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
April 6, 2011 at 3:47 am
Sanz (4/6/2011)
There is no difference in any of settings you mentioned.
Are you sure? SSMS has different defaults for some of the SET options than ADO.Net does. How did you check...
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
April 6, 2011 at 3:42 am
Inserts won't change the last seek, scan or lookup date. Only something that reads the table (select, update, delete) will change those.
If you think it's a bug, file it on...
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
April 6, 2011 at 3:37 am
Is it all indexes on a certain table? Just one index on the table?
Are you 100% sure the table's in use, not maybe a copy of the table in a...
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
April 6, 2011 at 3:29 am
- Win. (4/6/2011)
4) Run checkpoint. It should flush your data from log to data file.How to from SQL Query to perform CHECKPOINT directly ?
Don't, it'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
April 6, 2011 at 3:27 am
Note that you will lose all logins, all linked servers, all server-level permissions and you will have to restore/attach all the user databases afterwards. You will also need to reinstall...
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
April 6, 2011 at 3:19 am
Did you read through the article I referenced?
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
April 6, 2011 at 3:18 am
Then SQL will throw errors when it hits the corruption, exactly as if will if there's one log file and it gets corrupted.
There is NO advantage, no benefit to having...
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
April 6, 2011 at 3:17 am
Please don't post multiple threads for the same question.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1088738-291-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
April 6, 2011 at 2:20 am
Viewing 15 posts - 26,836 through 26,850 (of 49,552 total)