Viewing 15 posts - 15,151 through 15,165 (of 49,552 total)
zulmanclock (12/19/2012)
then there are entries ot No I/O activity on all the databases then the I/O activity resumes then the databases are backed up again. Is this normal?
That's another...
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, 2012 at 10:26 am
sqlfriends (12/19/2012)
I just want to know why this happens?
The developers implemented retry logic. The app doesn't keep persisted connections. The app uses a disconnected model. Many other possibilities.
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, 2012 at 9:35 am
Dave Ballantyne (12/19/2012)
Update them , then run the queries again (using WITH RECOMPILE) and see what the plans look like.
No need to use recompile. The stats update alone would invalidate...
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, 2012 at 9:33 am
Parameter sniffing, or lack thereof. Probably combined with stale statistics so that SQL gets a completely incorrect row estimate when it can sniff the 'parameters' (in this case string literals)...
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, 2012 at 9:21 am
It'll likely be the sort spilling to TempDB. If you look in the default trace you'll see the sort warning in there. Sorts very commonly spill, especially if there're on...
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, 2012 at 9:09 am
Satish Hottur (12/19/2012)
I am trying to findout how it works internally......:crying:
How what works? The graphical view of the XML file? That's just an SSMS feature, the management tool can interpret...
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, 2012 at 9:06 am
First thing. Is that query a problem?
The percentages in the plan must add up to 100%, so the fact that a scan is 87% is not necessarily a problem.
If the...
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, 2012 at 5:53 am
abitguru (12/19/2012)
We dont use auto update. And is hard to find a "slow/off time" .. you know. We are thinking the best way to schedule to run in spare time.
If...
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, 2012 at 5:51 am
If I may suggest...
If this is just for experimentation, that's fine. If this is a design for an app, just don't do this. You're opening yourself to all sorts 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
December 19, 2012 at 1:32 am
What specifically are you looking to know and why?
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, 2012 at 1:27 am
Could you be more specific about what you're trying to do?
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, 2012 at 12:20 am
Just to reiterate here...
GilaMonster (12/18/2012)
Don't use Task Manager to check SQL's memory. It can be completely wrong.
Use Perfmon with either the SQL Server memory counters and/or the process-specific counters.
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, 2012 at 12:06 am
Don't use Task Manager to check SQL's memory. It reports incorrect values.
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, 2012 at 4:27 pm
Evil Kraig F (12/18/2012)
Mind you, a good book on first skim (thinking something like Dresden Files here) will take me 5-8 hours to blow through.
I can read one of the...
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, 2012 at 4:26 pm
D-SQL (12/18/2012)
Datawarehouse recomended trace flags that need to be set to help performance
None, unless you are having specific problems that the traceflags address.
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, 2012 at 4:22 pm
Viewing 15 posts - 15,151 through 15,165 (of 49,552 total)