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...
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.
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...
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)...
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...
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...
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...
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...
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...
December 19, 2012 at 1:32 am
What specifically are you looking to know and why?
December 19, 2012 at 1:27 am
Could you be more specific about what you're trying to do?
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.
December 19, 2012 at 12:06 am
Don't use Task Manager to check SQL's memory. It reports incorrect values.
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...
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.
December 18, 2012 at 4:22 pm
Viewing 15 posts - 15,151 through 15,165 (of 49,552 total)