May 26, 2008 at 11:42 pm
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
May 27, 2008 at 2:06 am
Nice article......:)
May 27, 2008 at 2:10 am
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
May 27, 2008 at 8:43 am
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.
May 27, 2008 at 9:28 am
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
May 27, 2008 at 9:37 am
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.
May 27, 2008 at 9:56 am
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.
May 27, 2008 at 10:51 am
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
The Redneck DBA
May 27, 2008 at 2:27 pm
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.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 27, 2008 at 4:23 pm
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
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply