Viewing 15 posts - 436 through 450 (of 560 total)
david.alcock (3/14/2013)
I might be confused, is it the xml plans that come up in the results, or an execution plan of the query you posted?
That column should provide a link...
March 14, 2013 at 3:59 pm
ASYNC_NETWORK_IO is a clear indicator of network problems, NIC issues, or large data sets being processed over the network. 😉
I am not surprise the Network team said there was no...
March 14, 2013 at 9:49 am
david.alcock (3/14/2013)
Presumably the plans are simply not in the cache any more. Can you re-run any of the queries and requery the DMV to see if it then appears?
Not...
March 14, 2013 at 9:41 am
GilaMonster (3/14/2013)
sql-lover (3/14/2013)
It was a test machine and have a fresh backup, so I restored from it, but it surprised me that the restart damaged the database.
What most likely happened...
March 14, 2013 at 9:38 am
GilaMonster (3/14/2013)
Recovery models have no effect on rollback, so doesn't matter which...
March 14, 2013 at 9:21 am
GilaMonster (2/15/2013)
It's used for the cluster's IsAlive check. It takes minimal resources. It wasn't there on SQL 2008 or below because it was only introduced in SQL 2012.
Thanks for reply!
Well,...
February 15, 2013 at 2:20 pm
Wow,
I asked our SAN expert to review the LUN configuration with me. And this was his response: "latency will go up once we go live, as this is a shared...
January 7, 2013 at 7:58 am
Perry Whittle (1/2/2013)
January 2, 2013 at 11:50 am
Leo.Miller (12/19/2012)If it says 4096 it is formatted with 4Kb allocation units. You want this to say 65536 i.e. 64Kb. This can make a noticeable change in disk performance.
Leo
Can you...
January 2, 2013 at 6:59 am
Yes, after last round of test and using 150GB file, I think that the 64KB test (writes and reads) looks good, specially the sequential.
Our systems are DW type...
December 19, 2012 at 2:06 pm
Hi Michael,
Thanks for reply.
While SAN and storage is not my main area of expertise, I do have a basic understanding of them and more important yet, how SQL interacts or...
December 19, 2012 at 12:50 pm
Increased the test file size to 150GB and performed another round of tests ...
64KB random IOs
sqlio v1.5.SG
using system counter for latency timings, 2474091 counts per second
parameter file used: data_param.txt
file E:\SQL_Data\MSSQL\testfile.dat...
December 19, 2012 at 9:25 am
charipg (12/19/2012)
thanks..will try and let you know...
Did you see Anthony's post? that's a good comment that I forgot to ask or mention.
Are you running out of space? Why are...
December 19, 2012 at 8:50 am
shindle 17293 (12/19/2012)
How does the Index Fill Factor influence the size of a compressed backup? Is the fill factor space that is empty ignored during a compressed backup?
Yes,
I do believe...
December 19, 2012 at 8:45 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...
December 19, 2012 at 8:32 am
Viewing 15 posts - 436 through 450 (of 560 total)