Viewing 15 posts - 26,881 through 26,895 (of 49,552 total)
I'd be far more worried about the cause than the effect. Those are minidumps, means that SQL is regularly throwing access violations.
Ensure that SQL is patched to the latest version,...
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 5, 2011 at 1:24 am
I strongly do NOT recommend mirroring with different versions. The mirror should also be 2008 if the principal is SQL 2008. The setup you described is intended to work 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 5, 2011 at 1:22 am
Yes, but it's not supported except during an upgrade scenario. (upgrading a 2008 mirror pair to 2008 R2). If you ever fail to the mirror, you will not be able...
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 4, 2011 at 11:50 pm
Could you please post new questions in a new thread? Thanks
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 4, 2011 at 11:45 pm
WayneS (4/4/2011)
SELECT * from tempdb.sys.tables
there are a handful of table variables in the results. Does anyone have an idea 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 4, 2011 at 11:44 pm
UMG Developer (4/4/2011)
I assume they are part of the CHECKDB process that runs when SQL Server starts.
CheckDB doesn't run when SQL starts.
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 4, 2011 at 11:42 pm
No, not unless you have a trigger on the table tracking that info or a column that's updated with date and time of modifications
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 4, 2011 at 11:34 pm
A database can have multiple ldf files. The question is, why would you want to? It gains you nothing.
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 4, 2011 at 11:25 pm
Eric M Russell (4/4/2011)
If you're not sure what to look for, then consider using the DTA (Database Engine Tuning Advisor) tool to analyze your query.
But take all of its recommendations...
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 4, 2011 at 12:36 pm
Grubb (4/4/2011)
So, why would the same plan take 1 ms at one execution, and 400x that in another?
1) Blocking
2) Waiting for resource
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 4, 2011 at 11:31 am
vmssanthosh (4/4/2011)
Yes it works for 2008 r2.. Our production server has 2008 r2 only. and we are using the same technique for truncating log files.
Why? Just take normal log backups....
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 4, 2011 at 11:23 am
SELECT value_in_use
FROM sys.configurations
WHERE name = 'max degree of parallelism'
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 4, 2011 at 9:23 am
Yes. Modify every single page in the database. The checksum only gets added on the next modification.
Easiest way to change most pages - rebuild all indexes on all tables.
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 4, 2011 at 9:21 am
Typically, badly written queries and/or poor indexing. Look at optimising the workload. If you don't have a clue how, consider getting someone in to help out.
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 4, 2011 at 5:25 am
If you're talking about scheduling via SQL agent, there can only be one instance of a job running. If a job is still running when it's next start time arrives,...
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 4, 2011 at 5:22 am
Viewing 15 posts - 26,881 through 26,895 (of 49,552 total)