Viewing 15 posts - 14,176 through 14,190 (of 49,552 total)
To run profiler or create traces requires either sysadmin or ALTER TRACE permission on the server. If they have neither (and devs shouldn't have either on a prod server), then...
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
February 23, 2013 at 3:32 am
Bulk logged is not usually an isolation level that's used for long periods of time, because of the risks involved (can't do point in time recovery to a log interval...
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
February 22, 2013 at 1:41 pm
Depends what you're doing, where the values for the proc come from, whether there are output procedures, etc.
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
February 22, 2013 at 11:47 am
ben.brugman (2/22/2013)
GilaMonster (2/22/2013)
ie, if PLE is 400, then on average a page is expected to remain in cache for 400 seconds.
Is that from the moment we measure. Or from 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
February 22, 2013 at 11:19 am
Page life expectancy is an instantaneous measure of how long (in seconds) a data file page is expected to remain in memory in the buffer pool (also referred to as...
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
February 22, 2013 at 10:13 am
Invalid object is not a run-time error, it's thrown in the parse/bind/optimise phase. Try catch catches run-time errors.
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
February 22, 2013 at 9:16 am
Check your IO subsystem? Could also be that CPU is being used elsewhere and the writing to the log file is getting delayed because the CPU is trying to process...
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
February 22, 2013 at 9:15 am
PLE is a historical average of how long a page remained in cache after having been read in.
As for a disfavoured page, it will remain in cache until something...
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
February 22, 2013 at 9:13 am
No to scraping the log file, no to separate locations.
The log records are written to the log file and sent to the mirror at the time they're created. No file...
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
February 22, 2013 at 8:11 am
Yup. You began the transaction twice and committed it once, thereby leaving the transaction open and all locks still held.
If you'd checked @@TranCount it would have shown 1, and DBCC...
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
February 22, 2013 at 8:08 am
Possibility 1: Nested Transactions.
Something like this:
Begin transaction
-- do some stuff
Begin transaction
-- do some more stuff
Commit transaction
That transaction is still open. The commit did nothing other than decrement the open transaction...
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
February 22, 2013 at 7:45 am
pooyan_pdm (2/22/2013)
What kind of overhead does this search have?
A lot. That XQuery is heavy on CPU on an unindexed column
Don't do that on a production server. At most, pull 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
February 22, 2013 at 6:02 am
If I Recall Correctly.
The kb article that Deque posted, titled "How to schedule and automate backups of SQL Server databases in SQL Server Express", gives detailed steps on how 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
February 22, 2013 at 3:40 am
pooyan_pdm (2/21/2013)
Thanks for your reply. I was looking for a way other than searching the plan cache.
The only way to find out what queries had specific query plan operators is...
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
February 22, 2013 at 3:27 am
Please note: 5 year old thread.
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
February 22, 2013 at 3:25 am
Viewing 15 posts - 14,176 through 14,190 (of 49,552 total)