Viewing 15 posts - 4,516 through 4,530 (of 49,552 total)
xsevensinzx (10/14/2015)
I think the reason why I went that option is because it's my understanding that with large volumes, it pays out in the end to split the indexes.
Maybe, maybe...
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 14, 2015 at 9:19 am
Bill Talada (10/14/2015)
My interpretation is that the graph process is creating a transaction before reporting and rolling back.
If that was the case, then it would be impossible to get a...
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 14, 2015 at 9:09 am
A shutdown doesn't necessarily cleanly shut all DBs down, and a checkpoint doesn't mean no recovery necessary, consider uncommitted transactions whose changes get written to disk as part of 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
October 14, 2015 at 8:44 am
They're not memory resident, however like normal tables and indexes they'll be read into memory to be used, as part of the buffer pool.
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 14, 2015 at 7:43 am
Huh? Don't understand, can you elaborate on your question?
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 14, 2015 at 7:31 am
xsevensinzx (10/13/2015)
RonKyle (10/13/2015)
A downside I've seen is that when I adopted this method I had to stop putting my indexes in a different file group because of the restore issues.
I...
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 14, 2015 at 7:29 am
Bill Talada (10/14/2015)
Your hypothesis is false as the following code will show a trancount=1:
BEGIN TRAN
SELECT @@trancount;
COMMIT;
Yes, that will return @@trancount of 1, but the OP's not talking about what @@trancount...
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 14, 2015 at 7:18 am
Documented? What's that? 🙂
It looks like if there's only auto-commit transactions (every statement starts and commits a transaction) then it's 0, if there's an explicit transaction, then you get a...
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 14, 2015 at 5:47 am
No, you can't have two instances with the same name.
You need to either:
Install a new instance with a different name, move the databases, uninstall the old instance, update...
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 14, 2015 at 3:02 am
don.schaeffer (5/12/2011)
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 13, 2015 at 7:11 am
Is opening a support call with MS an option? If so, I'd recommend that approach.
Also check the IO subsystem for any errors in any drivers, caches, etc. Make sure firmware...
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 13, 2015 at 6:21 am
Thank you (I can see the posts, they're pending approval due to the spam filter)
Can you also please post the actual execution plan, as a .sqlplan 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
October 13, 2015 at 4:29 am
Put the keyboard down, pet the cat. Priorities!
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 13, 2015 at 4:09 am
The inserted and deleted pseudo-tables are only visible in the trigger's scope, not in any child scope (dynamic SQL, functions or procedures)
It looks like you're trying to write a trigger...
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 13, 2015 at 4:06 am
Eirikur Eiriksson (10/13/2015)
Quick question, have you considered turning on compression on those tables and indices, most likely more effective and almost no risk involved.
Seconded. Row compression has very little overhead,...
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 13, 2015 at 3:12 am
Viewing 15 posts - 4,516 through 4,530 (of 49,552 total)