Viewing 15 posts - 6,856 through 6,870 (of 49,552 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.
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
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...
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
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...
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
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...
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
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)
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
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...
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
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)
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
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...
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
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 -...
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
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: 😀
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
January 6, 2015 at 1:12 pm
10GB limit for SQL Express 2008 R2, 1 core, 1 GB memory, no SQL Agent.
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
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...
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
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...
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
January 6, 2015 at 7:16 am
Real data that is used for business decisions? Production.
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
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.
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
January 6, 2015 at 6:15 am
Viewing 15 posts - 6,856 through 6,870 (of 49,552 total)