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...
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...
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.
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
February 22, 2013 at 3:27 am
Please note: 5 year old thread.
February 22, 2013 at 3:25 am
Viewing 15 posts - 14,176 through 14,190 (of 49,552 total)