Viewing 15 posts - 5,866 through 5,880 (of 49,552 total)
Almighty (5/20/2015)
as said earlier .. check the reason of log not shrinkingin log _reuse_wait column
Log_reuse_wait has nothing to do with the log not shrinking. It tells you...
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
May 20, 2015 at 12:15 am
Jason A. Long (5/19/2015)
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
May 20, 2015 at 12:12 am
ramana3327 (5/19/2015)
To reduce the VLFs. I saw when the log file is large it has more no of vlfs
Well, yes, of course it will. VLFs have a certain max size...
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
May 20, 2015 at 12:06 am
Please, please, please get and read that book.
Most of the waits in the picture are ones we don't care about (sleep is supposed to be high). There's a script in...
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
May 20, 2015 at 12:05 am
ramana3327 (5/19/2015)
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
May 19, 2015 at 4:26 pm
No, and rebuild doesn't use TempDB instead of the log either. Rebuild uses TempDB for sort space, space that would otherwise come from the user database's data file. Reorganise doesn'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
May 19, 2015 at 9:33 am
SQLRNNR (5/19/2015)
Or do you...
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
May 19, 2015 at 9:22 am
Don't fixate on one thing, you need a lot of stats and a lot of information to start diagnosing.
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
May 19, 2015 at 9:11 am
You lose any permissions that were on the object, if that can be called an advantage.
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
May 19, 2015 at 7:13 am
https://msdn.microsoft.com/en-us/library/ff878487.aspx -- the 2014 BoL
Each server instance must be running the Enterprise Edition of SQL Server 2014.
https://msdn.microsoft.com/en-us/library/ff878487(v=sql.110).aspx -- the 2012 BoL
Each server instance must be running the Enterprise Edition...
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
May 19, 2015 at 6:46 am
mandirkumar 18293 (5/19/2015)
1.Why indexes and statistics are considered as duplicate .means statistics on tbl1(col1) and index on tbl1(col1) are considered as duplicate
A stats set and an index aren't duplicates and...
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
May 19, 2015 at 6:13 am
Almighty (5/19/2015)
Gail Is there something called Non-destructive shrinking ??
Well shrinking's never destructive.... I said it's bad practice, not that it's going to destroy something.
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
May 19, 2015 at 5:44 am
christian_t (5/19/2015)
Am I waisting my time?
Yes.
Cross-version is only for rolling upgrades, not as a permanent scenario.
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
May 19, 2015 at 5:42 am
ramana3327 (5/18/2015)
2) I shrink the log file only 2 times. If I want to shrink the log file everyday after the maintenance job it will impact any performance?
Yes. Do not...
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
May 19, 2015 at 5:21 am
Pretty much. By adding one day to the end of the range, you're getting all the date-times on that day, right up to just before midnight at the end 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
May 19, 2015 at 4:22 am
Viewing 15 posts - 5,866 through 5,880 (of 49,552 total)