Red Gate forums :: View topic - Does SQLDoc it affect the DB in any way such as performance?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

Does SQLDoc it affect the DB in any way such as performance?

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
bbutler99a



Joined: 08 Mar 2010
Posts: 6

PostPosted: Tue Mar 09, 2010 11:26 pm    Post subject: Does SQLDoc it affect the DB in any way such as performance? Reply with quote

We have "production runs" that use the DB and want to make sure that we do not affect anything when we run SQLDoc against the database that the production run is using, while the production run is running. I assume there will be the affect of getting the metadata from the tables, but that should be minimal on performance. Any other issues? Someone was worried that running at the same time would cause a "locking" problem. I don't see anything that SQLDoc modifies, so I think it only reads and does not do any locking. Thanks for any info.
Back to top
View user's profile Send private message
bbutler99a



Joined: 08 Mar 2010
Posts: 6

PostPosted: Thu Mar 11, 2010 3:15 pm    Post subject: Issues with updates and dirty reads? Reply with quote

To be clear, two main questions are:
- does SQLDoc do dirty reads?
- does it do any updates?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Mar 11, 2010 9:33 pm    Post subject: Reply with quote

Hi Bret,

As far as I am aware, SQL Doc shouldn't impact the performance of a server at all providing of course that you don't have the tool installed on the server itself.

It certainly isn't anything I have come across before, however if you are very worried about it by all means download a trial version and run it against a test DB. I really don't believe you would see any performance issues though.

With regards to updates, the only updates it would perform on the DB would be if you were to alter any of the MS_Descriptions on objects. If you altered these through the tool then yes, it would be performing an update on the database schema.

Hope that helps!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
bbutler99a



Joined: 08 Mar 2010
Posts: 6

PostPosted: Thu Mar 11, 2010 10:06 pm    Post subject: Thanks! That's what I needed Reply with quote

Rock on!
Back to top
View user's profile Send private message
rick.sheeley



Joined: 21 Dec 2006
Posts: 23
Location: Bay Area, CA

PostPosted: Wed Sep 15, 2010 9:46 pm    Post subject: impact... Reply with quote

bbutler,

I've seen zero impact here at Banner....
_________________
Eric (Rick) Sheeley, Sr. SQL/Oracle DBA
Sacramento, CA Cell: 602.540.6750
"Those are my principles, and if you don't like them... well, I have others." - Groucho Marx
Back to top
View user's profile Send private message Send e-mail MSN Messenger
bbutler99a



Joined: 08 Mar 2010
Posts: 6

PostPosted: Fri Sep 17, 2010 8:17 pm    Post subject: Thanks for the info Reply with quote

I appreciate the info folks. We have been using it without problems.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group