Viewing 15 posts - 11,011 through 11,025 (of 49,566 total)
d_uvarajan (11/9/2013)
Attached the execution plan. Please refer "Query 54" in the plan.
Query 54 is 0% of the cost of the batch. Why do you think it's the problem?
Can you go...
November 11, 2013 at 1:13 am
Jeff Moden (11/10/2013)
November 11, 2013 at 12:02 am
Jonathan's Troubleshooting book, memory chapter.
November 10, 2013 at 11:56 pm
Possible, yes, but a really bad idea. Failover would work, providing you have no Enterprise-only features but you wouldn't be able to fail back.
DR should be the same version, edition,...
November 10, 2013 at 11:55 pm
3GB max to start with. Adjust as necessary.
Still consider upgrading to 64-bit, if you've got a linked server driver causing MemToLeave problems, enabling AWE is not going to make it...
November 10, 2013 at 10:12 pm
Yup, 32 bit. You don't have AWE enabled, so SQL can only use 1.7 GB of memory. You're probably running into fragmented virtual address space (or are out of virtual...
November 10, 2013 at 11:57 am
homebrew01 (11/9/2013)
Maybe the backups are getting corrupted somehow during ftp to the target servers.
Wouldn't be the first time I've heard of that happening.
November 10, 2013 at 2:55 am
Should be in one of these:
http://technet.microsoft.com/en-us/sqlserver/gg313760.aspx
http://technet.microsoft.com/en-us/sqlserver/gg508878.aspx
I don't offhand know of any articles specifically on page splits and I'm sure you can google as well as I can.
November 9, 2013 at 12:42 pm
That'll require half an article to explain from start to finish. Any specifics you want clearing up?
November 9, 2013 at 8:16 am
That the database is in a restoring state (it's in the middle of a restore) and hence SQL can't run recovery on it at this point in time.
November 9, 2013 at 2:03 am
Start with these:
http://www.sqlservercentral.com/articles/Indexing/68439/
November 8, 2013 at 11:24 am
This perhaps?
Or other parameter sniffing problem. Basically, SQL can sniff parameter values and use those to estimate row counts for query optimisation. It can't with variables. If it gets that...
November 8, 2013 at 8:46 am
The key is just what edition gets installed. With the possible exception of one of 2012's editions, the key in no way affects the cores you can use or SQL...
November 8, 2013 at 2:04 am
What log messages specifically are you seeing?
November 7, 2013 at 11:50 pm
Viewing 15 posts - 11,011 through 11,025 (of 49,566 total)