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

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

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

Postby bbutler99a » Tue Mar 09, 2010 11:26 pm

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.
bbutler99a
 
Posts: 6
Joined: Mon Mar 08, 2010 2:53 pm

Issues with updates and dirty reads?

Postby bbutler99a » Thu Mar 11, 2010 3:15 pm

To be clear, two main questions are:
- does SQLDoc do dirty reads?
- does it do any updates?
bbutler99a
 
Posts: 6
Joined: Mon Mar 08, 2010 2:53 pm

Postby peter.peart » Thu Mar 11, 2010 9:33 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Thanks! That's what I needed

Postby bbutler99a » Thu Mar 11, 2010 10:06 pm

Rock on!
bbutler99a
 
Posts: 6
Joined: Mon Mar 08, 2010 2:53 pm

impact...

Postby rick.sheeley » Wed Sep 15, 2010 9:46 pm

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
rick.sheeley
 
Posts: 23
Joined: Thu Dec 21, 2006 5:42 pm
Location: Bay Area, CA

Thanks for the info

Postby bbutler99a » Fri Sep 17, 2010 8:17 pm

I appreciate the info folks. We have been using it without problems.
bbutler99a
 
Posts: 6
Joined: Mon Mar 08, 2010 2:53 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 1 guest