Viewing 15 posts - 10,291 through 10,305 (of 49,552 total)
JustMarie (1/22/2014)
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
January 22, 2014 at 1:23 pm
Welsh Corgi (1/22/2014)
Another backup, that log file has not changed in size.
No, it won't. Log backups do not shrink the file. Though, if it hasn't changed in size that means...
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
January 22, 2014 at 8:29 am
satish.saidapur (1/22/2014)
Hi Gail,Same query using which i shared, could you current me if i wrong or advice me which query shall i use..
The query 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
January 22, 2014 at 8:13 am
Log backups don't shrink the log, they're not expected to shrink the log. They mark the space within the log file as reusable. What you describe is normal and expected.
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
January 22, 2014 at 8:12 am
That query does not get you the top 10 CPU-using queries.
It gets you a (fairly meaningless) set of the top 10 wait types. I say meaningless, because it hasn'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
January 22, 2014 at 7:41 am
Suspended just means it's waiting for something, probably a lock or IO. Be patient.
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
January 22, 2014 at 7:39 am
You shouldn't even be shrinking the log. If the log is growing, make the log backup more frequent or identify what is causing the log growth and resolve it.
btw, going...
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
January 22, 2014 at 7:00 am
Have you confirmed that the subquery, function on a constant and conversion in the select are the causes of the poor performance?
If you haven't, then making the changes you request...
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
January 22, 2014 at 3:01 am
thbaig1 (1/17/2014)
I have several rule on my item name to compute its gender. I know this structure might need to tune , but currently can't change:(
I wrote sql and its...
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
January 22, 2014 at 12:12 am
Clustered indexes over multiple columns isn't usually a great idea. What are you trying to achieve?
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
January 22, 2014 at 12:10 am
What is the exact command you are using to backup the log (or if a maintenance plan, what are the exact options)?
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
January 21, 2014 at 10:31 pm
mario17 (1/21/2014)
While doing INTO you lock tables fro the whole duration of your query.While loading result into pre-allocated is not, (or significantly decrease locking time)
That was fixed in SQL 7...
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
January 21, 2014 at 10:23 pm
Selects do not take exclusive locks unless there's a locking hint and they do not hold locks until the end of the transaction unless there's a locking hint.
Sure 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
January 21, 2014 at 4:11 pm
In the default isolation level shared locks (from selects) are held no longer than the end of the statement. Exclusive locks (from data modifications) are held until 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
January 21, 2014 at 3:40 pm
Insert ... Select can also be minimally logged.
Though how much it matters with temp tables which don't log redo information as it it (which is most of what's different between...
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
January 21, 2014 at 12:02 pm
Viewing 15 posts - 10,291 through 10,305 (of 49,552 total)