Viewing 15 posts - 6,856 through 6,870 (of 49,571 total)
Not 4000 locks total. 4000 locks on the same object from the same session. If that did happen, then that would have triggered a lock escalation to table.
January 7, 2015 at 6:27 am
DBA_Learner (1/7/2015)
Can someone please clarify me about how to design HA environment with RTO 100%.
Um, good luck with that.
That means no maintenance windows, no downtime at all, for...
January 7, 2015 at 6:23 am
After the fact, you wouldn't. 🙁
In short, if a single session is holding a lot of locks on a single object (>4000) or lock memory is taking up a large...
January 7, 2015 at 4:48 am
muralikrishna2489 (1/7/2015)
I was advised that Since both Changes and Changes_DupCK table has millions of data , Giving UNION ALL will impact the database speed.
May I suggest you read through...
January 7, 2015 at 4:12 am
Stale statistics
Plan regression due to data volume changes
Lack of lock memory, resulting an a lock escalation
etc
Could be a number of things, hard to say without any details (code, plan, etc)
January 7, 2015 at 4:07 am
Execution plan?
muralikrishna2489 (1/7/2015)
Please optimize my code to tune the database performance as I am using Union ALL in my query which will impact database as it has more unique datas.
Does...
January 7, 2015 at 3:16 am
For performance questions, we really need to see table definitions, all index definitions and the actual execution plan (saved as a .sqlplan file and attached)
January 7, 2015 at 1:45 am
Rajneeshyadav18 (1/6/2015)
GRANT IMPERSONATE ON USER::DBO TO [userlogin];
????????
Why would you give an application account permission to impersonate the database owner. That essentially gives then DB_owner permissions.
Not exactly adhering to the principle...
January 7, 2015 at 1:36 am
SQL Guy 1 (1/6/2015)
This is the reason why I asked a question about placing dist into memory at my initial post.
The thing is, in-memory solves a particular problem -...
January 7, 2015 at 1:34 am
Alvin Ramard (1/6/2015)
RamSteve (1/6/2015)
HI ,...
So should i need to take any other precautions or concerns with this approach.?
...
Yes, update your resume every 2 weeks!
Hahahahahaha :hehe: 😀
January 6, 2015 at 1:12 pm
10GB limit for SQL Express 2008 R2, 1 core, 1 GB memory, no SQL Agent.
January 6, 2015 at 1:10 pm
One full backup every 5 years and one transaction log backup every month???
I do hope that client's data loss allowance in the case of a disaster is 'all of it'.
Maybe...
January 6, 2015 at 1:02 pm
You'll need to normalise your table design (attributes should be atomic and a comma-delimited string is not atomic) or use a split function.
As John requested
Please post (for both tables) DDL...
January 6, 2015 at 7:16 am
Real data that is used for business decisions? Production.
January 6, 2015 at 7:04 am
Instant file initialisation requires that the SQL Server service account has the 'perform volume maintenance task' permission. The account used to connect to SQL to do the restore is irrelevant.
January 6, 2015 at 6:15 am
Viewing 15 posts - 6,856 through 6,870 (of 49,571 total)