Viewing 15 posts - 11,146 through 11,160 (of 49,552 total)
Don't look at scan count. It is not the number of times a table has been scanned, it's not consistently the number of times a table has been accessed either.
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
October 30, 2013 at 7:37 am
No. That'll be an efficient lazy writer (freeing up buffers before they're needed)
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
October 30, 2013 at 7:36 am
Lock timeouts can cause a delete to fail and roll back entirely. I don't know offhand what error you'd get or where you'd see it.
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
October 30, 2013 at 7:35 am
This:
One of the things you're missing there is that you're looking for the longest running queries, not the highest impact queries. As such, you'll see the query that runs 10...
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
October 30, 2013 at 1:06 am
Are you looking at stats associated with an index? Those can only be dropped by dropping the index. Otherwise the drop stats option should work. Otherwise the DROP STATISTICS statement
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
October 30, 2013 at 12:45 am
patrickmcginnis59 10839 (10/29/2013)
Its interesting to ruminate on why this situation seems so offensive to some. Aren't folks doing the interview for free anyways?
Interview != consulting services. The premise of an...
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
October 29, 2013 at 3:10 pm
There isn't really a way. You could run traces or extended events sessions and correlate the times of log growth to operations, but that's impractical for long periods.
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
October 29, 2013 at 1:28 pm
PRR.DB (10/29/2013)
So i tried so many ways, but it is not.
now it showing...
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
October 29, 2013 at 1:24 pm
Stefan Krzywicki (10/29/2013)
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
October 29, 2013 at 1:20 pm
*sigh* More contract work requests in the month since I resigned than in the 4 months prior to that.
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
October 29, 2013 at 12:35 pm
As in what? Delete rows other than the ones you asked to be deleted? No. All locks and lock timeouts can do is make a statement wait or fail entirely...
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
October 29, 2013 at 6:46 am
No, that's describing the write portion of scatter-gather IO, not a read operation.
Why would you expect to see an increase in lazy writes/sec when all you're doing are reads? No...
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
October 29, 2013 at 5:36 am
""
Ok, what browsers is everyone useing
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
October 29, 2013 at 5:33 am
djordan 4543 (10/29/2013)
I am wondering if these lock timeouts would be causing the database would not to be updating correctly (i.e deleting)?
You mean you issue an update and the affected...
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
October 29, 2013 at 5:04 am
No. Deleted log file breaks the log chain (among the nasty things if can do), so you need a full or diff backup (probably full) applied to the secondary to...
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
October 29, 2013 at 4:55 am
Viewing 15 posts - 11,146 through 11,160 (of 49,552 total)