| Author |
 Topic  |
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
 Posted - 11/26/2012 : 10:37:26 AM
|
I'm really starting to think that clients that deploy Standard Edition for SQL 2008 in the enterprise are causing themselves problems.
For instance, I have a client with enterprise Share Point.
For backups he uses DPM. The logs are full of "I/O is Frozen", "I/O is Resumed" with frequent database backups.
I did not set that up. The DPM backups is not a SQL backup and when run dbcc loginfo against a transaction log you can see all the files within the transaction log are not changed unless you run proper backups against the log files after making sure the data was committed to disk.
User complaintes of slow response could be linked IMHO to the constant reconnection of the Share Point services to the database by the many services and account authentications running these services.
Would not the load of enterprise applications need enterprise SQL?
Since I am not part of Microsoft Marketing and don't get a dime from a firm's decision, what can we say to make the case for enterprise aside from cost issues?
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
JamesNT
Moderator
USA
3151 Posts
Status: offline |
Posted - 11/26/2012 : 11:34:17 AM
|
When considering the fact that the only difference between SQL Standard and SQL Enterprise is the ability to address more RAM, more CPU, and a few additional BI features, I actually have a hard time with the idea that the edition of SQL could have that much of an impact.
Of course, if you really needed that much CPU/RAM, you could tell that from perf mon.
JamesNT |
James Summerlin
www.jamessummerlin.com |
 |
|
|
wobble_wobble
Honorable But Hopeless Addict
Ireland
4524 Posts
Status: offline |
Posted - 11/26/2012 : 2:56:58 PM
|
Change the DPM backup for a a day.
Use WSS Backup for the SP backup and see if there is the same issue. |
Joe
After everything that has happened during the month of Jan 07, I do believe that pigs fly backwards!
http://whatismyv6.com/ |
|
|
|
NMDANGE
Honorable But Hopeless Addict
USA
2063 Posts
Status: offline |
Posted - 11/26/2012 : 3:28:05 PM
|
| What version of DPM? If DPM is protecting a SQL Server, it should do transaction log backups (unless the database in question is in SIMPLE recovery mode, or the database is part of a mirror/transaction log shipping pair) |
Michael D'Angelo
(former)MVP-MIIS, Pace University Senior Systems Administrator (Windows)
(MS)NMDANGE
PhoeniX WorX Systems Administrator. If you play Total Annihilation, please join us. http://www.phoenixworx.org |
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 11/26/2012 : 3:51:31 PM
|
DPM backups don't commit data to disk.
quote:
Originally posted by NMDANGE
What version of DPM? If DPM is protecting a SQL Server, it should do transaction log backups (unless the database in question is in SIMPLE recovery mode, or the database is part of a mirror/transaction log shipping pair)
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
|
NMDANGE
Honorable But Hopeless Addict
USA
2063 Posts
Status: offline |
Posted - 11/26/2012 : 4:23:20 PM
|
| Actually it will create a folder named "DPM_SQL_PROTECT" where the transaction logs live, then do a transaction log backup to a file, which is then backed up into DPM via the DPM agent. I confirmed this is how my installation of DPM 2010 is functioning. It may only do this if you configure synchronization to a fixed interval (as opposed to "just before a recovery point") |
Michael D'Angelo
(former)MVP-MIIS, Pace University Senior Systems Administrator (Windows)
(MS)NMDANGE
PhoeniX WorX Systems Administrator. If you play Total Annihilation, please join us. http://www.phoenixworx.org |
|
|
|
Curt
Moderator
USA
6659 Posts
Status: offline |
Posted - 11/26/2012 : 4:31:56 PM
|
Thanks. I try it out in my lab before suggesting it to the client.
Thanks Mark.
quote:
Originally posted by NMDANGE
Actually it will create a folder named "DPM_SQL_PROTECT" where the transaction logs live, then do a transaction log backup to a file, which is then backed up into DPM via the DPM agent. I confirmed this is how my installation of DPM 2010 is functioning. It may only do this if you configure synchronization to a fixed interval (as opposed to "just before a recovery point")
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
| |
Topic |
|
Does the SQL version impact the application.
