Viewing 15 posts - 32,596 through 32,610 (of 49,552 total)
It is impossible for a page to be shared between two tables. Pages will only ever contain rows from a single table.
Can you post definitions and index definitions 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
June 4, 2010 at 10:54 am
GilaMonster (6/4/2010)
The rebuild of all indexes (cluster and noncluster) will put checksums onto most pages. Some, like LOB pages may not be touched by rebuilds though.
If the IO subsystem has...
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
June 4, 2010 at 10:39 am
Interesting.
What I suggest is that you go through all of the attributes in sys.dm_exec_plan_attributes, one of the columns in there is 'is_cache_key'. If any attributes with that column = 1...
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
June 4, 2010 at 10:22 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic932919-391-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
June 4, 2010 at 10:08 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic932919-391-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
June 4, 2010 at 10:08 am
Deb Anderson (6/4/2010)
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
June 4, 2010 at 9:50 am
What does this return? Should be safe to post, there's no info on the query or plan anywhere in there.
SELECT cp.plan_handle, cp.cacheobjtype, cp.refcounts, cp.usecounts,
pa.attribute, pa.value
FROM sys.dm_exec_cached_plans cp
CROSS APPLY sys.dm_exec_plan_attributes(cp.plan_handle)...
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
June 4, 2010 at 9:30 am
Edit: On second thoughts....
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
June 4, 2010 at 9:19 am
Ray K (6/4/2010)
Is there something I'm missing?
Nope. There's no concatenation of user-inputted values directly into the string, so that's pretty safe as you've done it.
Just one small point, you don't...
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
June 4, 2010 at 9:10 am
Are all 12 plan handles different?
Could you perhaps attach the results as an excel sheet? Without seeing results, hard to tell you why there are multiple rows. Can you also...
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
June 4, 2010 at 8:40 am
Deb Anderson (6/4/2010)
so, utilizing the checksum will give me some peace of mind that the greatest source of my data corruption (i/o subsystem malfunctions) is being monitored.
But it's not being...
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
June 4, 2010 at 8:13 am
Be careful. The minimum acceptable frequency of CheckDB should be influenced by the retention period of your backups. The idea is that checkDB should run often enough that, should 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
June 4, 2010 at 7:58 am
Page verification is not a replacement for checkDB, it's not going to safely allow you to reduce the frequency of CheckDB. Something still needs to read the pages and 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
June 4, 2010 at 5:02 am
Bhuvnesh (6/4/2010)
Nils Gustav Stråbø (6/3/2010)
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
June 4, 2010 at 4:55 am
mchofman (6/4/2010)
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
June 4, 2010 at 4:46 am
Viewing 15 posts - 32,596 through 32,610 (of 49,552 total)