Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Snapshots Expand / Collapse
Author
Message
Posted Monday, May 26, 2008 11:42 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 14, 2011 7:53 AM
Points: 78, Visits: 344
Comments posted to this topic are about the item Database Snapshots

Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
Post #506674
Posted Tuesday, May 27, 2008 2:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,303, Visits: 1,378
Nice article......:)


Post #506736
Posted Tuesday, May 27, 2008 2:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:08 AM
Points: 1,230, Visits: 1,194
Thanks for the article.

I wonder how good it would be to use for it reporting purposes.

Besides reports running on the same server as a production db & the added overhead the older the snapshot is; what other performance issues should one consider/expect?

Thanks,
Lian
Post #506741
Posted Tuesday, May 27, 2008 8:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 29, 2009 6:34 AM
Points: 15, Visits: 23
Since this feature applies only to the Enterprise version, it would be nice if users were informed of the limitation before the click. I doubt that I am the only person to unnecessarily open the artice.
Post #506962
Posted Tuesday, May 27, 2008 9:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 14, 2011 7:53 AM
Points: 78, Visits: 344
If you have read the introduction it cleary states that it is the Enterprise only edition. Please read carefully before you comment on any thing.


Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
Post #507011
Posted Tuesday, May 27, 2008 9:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 29, 2009 6:34 AM
Points: 15, Visits: 23
Well, rookie, take your own advice. I did not say or imply that I read the whole article. I did read the intro and bailed out when I saw the Enterprise restriction.

What I wrote about was unnecessarily clicking into the article because there was no restriction mentioned to prevent navigating to the article.

Another word of advice, lighten up.
Post #507019
Posted Tuesday, May 27, 2008 9:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 7:49 PM
Points: 150, Visits: 497
In the 3 companies I've worked for, none had the Enterprise Edition.

It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus Enterprise.

Enterprise costs a lot more $ but doesn't really contain that many additional features that are useful to me.
Post #507041
Posted Tuesday, May 27, 2008 10:51 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:18 AM
Points: 1,491, Visits: 2,114
John Bates (5/27/2008)
In the 3 companies I've worked for, none had the Enterprise Edition.

It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus Enterprise.

Enterprise costs a lot more $ but doesn't really contain that many additional features that are useful to me.


An interesting point. I just made a survey for this question.

http://www.sqlservercentral.com/Forums/Topic507082-149-1.aspx


Jason Shadonix
MCTS, SQL 2005
Post #507091
Posted Tuesday, May 27, 2008 2:27 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:05 PM
Points: 2,644, Visits: 824
John Bates (5/27/2008)
In the 3 companies I've worked for, none had the Enterprise Edition.

It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus Enterprise.

Enterprise costs a lot more $ but doesn't really contain that many additional features that are useful to me.


I agree. When evaluating needs vs edition features for our organisation's new database servers, there wasn't enough justification to recommend going to Enterprise Edition given the price hike vs additional features offered. Some things like online index rebuilds would've been nice to have, but not at the price and not for what we were going to be running on the servers.





Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Post #507257
Posted Tuesday, May 27, 2008 4:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:35 AM
Points: 10, Visits: 273
Good article. I might have missed it but I'm guessing that ideally you would want to place the snapshot on a different drive?

JC


-----
James Cornell
Kainell Database Specialists
http://www.kainell.com
Post #507311
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse