Viewing 15 posts - 7,006 through 7,020 (of 49,552 total)
Different entries in the plan cache, very likely the same plan form, but two different plan objects in cache.
The queries would have to be an exact text match to have...
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
December 19, 2014 at 4:46 am
sej2008 (12/19/2014)
i am talking abt Sql 2012 High Availability group that requireswfc.
SQL Server failover clustering or Always On Availability Groups? Your posts are not clear as to which you're...
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
December 19, 2014 at 1:38 am
Brandie Tarvin (12/18/2014)
So, I'm curious. Anyone have any major projects that people want before the end of the year?
Yes. The complete reverse engineer and rewrite of a crop modelling system,...
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
December 18, 2014 at 5:31 am
Only checksum = you have no idea if your backup file is damaged
Only verify only = you have no idea if your backup file is damaged
Both - you have...
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
December 18, 2014 at 5:26 am
Are you appending to the file when taking 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
December 18, 2014 at 5:24 am
Ignore scan count. It is not the number of times a table has been scanned.
As for the high logical reads:
Large table
No indexes
Non-optimal execution plan
Poorly written query
Poor table design
Pick any 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
December 18, 2014 at 3:52 am
Blocking? Something on that server has rows for november locked?
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
December 18, 2014 at 3:30 am
Grant Fritchey (12/17/2014)
Check the error log. You can see when backups were fired off there.
Error log will also tell you the login name used.
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
December 18, 2014 at 3:29 am
Depends
Are you talking about Always On Windows Clustering or Always On Availability Groups?
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
December 18, 2014 at 3:13 am
Steps 4 and 8 both invalidate/remove the cached plan from cache forcing the optimiser to create a new execution plan
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
December 18, 2014 at 1:54 am
None of the rest require sysadmin, and to be honest you probably shouldn't be letting an app make random login changes. It has no business doing so (and that would...
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
December 18, 2014 at 1:51 am
As long as, when the service restarts, the system database files have the exact same path and name and SQL has full permissions on files and folders, you should be...
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
December 18, 2014 at 1:47 am
Via windows scheduler? Via an application?
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
December 18, 2014 at 1:42 am
The other thing to think about is that the database is the unit of restores. Will you ever be required to revert customer 42's data back to how it was...
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
December 18, 2014 at 1:41 am
Express12 (12/17/2014)
How can I restore the DB to multiple MDF's, NDF's across our 3 drives ( E: F: G: )
You can't.
A backup, no matter how many...
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
December 18, 2014 at 1:24 am
Viewing 15 posts - 7,006 through 7,020 (of 49,552 total)