Activity overview
Latest activity by cpdaniel
Enhancement request - Let users vote on enhancement requests
Most enhancement requests on this forum are followed up by a reply indicating that the requested enhancement is already covered by an existing work item in red-gate's tracking system. My suggestio...
As an alternative, rather than adding an option, simply suppress extended properties from the script fragments in the documentation entirely, or suppress only MS_Description extended properties, as these already appear in the documentation elsewhere and don't add any information for the reader of the document. / comments
As an alternative, rather than adding an option, simply suppress extended properties from the script fragments in the documentation entirely, or suppress only MS_Description extended properties, as...
Enhancement request - support MS_Description on UDT columns
SQL Server supports extended properties on the columns of a user-defined table type, but SQL Doc does not see those EPs nor use them in producing the documentation.
Enhancement request - Better handling of computed columns
The generated documentation for a table with a computed column is rather awful. The space allocated for the computed column specification is only a few characters wide, so a lengthy computed colum...
Enhancement request - Omit extended properties from scripts
Please add an option to omit the extended properties from the create scripts that are embedded in the document - this information is redundant and unhelpful in the SQL script.
Enhancement request - MS_Description for database roles
SQL Doc discovers and uses the MS_Description extended property on many objects. Unfortunately, database roles are not among them.
Please update SqlDoc to pick up MS_Description extended propertie...
+1 It would be very handy to have column meta-data for views. / comments
+1 It would be very handy to have column meta-data for views.
Any other suggestions? / comments
Any other suggestions?
StephenC wrote:
Hi,
In general the options grey out if the add-in doesn’t understand the project type. I think MVC ASP.NET applications produce this, but things like COM+ apps and services will confuse it as well. (Which in a way is fair enough, as these have to be installed after compiling and ANTS can’t do that for you)
The solution I'm working in now contains 22 projects:
2 .NET EXE projects (one console, one WinForms)
1 VC++ Makefile project (used to automate a bunch of post-build stuff)
19 .NET DLL projects, of which 7 are VSTS unit test projects.
The Makefile project is the Startup Project in the solution.
If I remember, I'll try opening a solution that doesn't have a Makefile project in it to see if that's throwing it off (seems like the most likely candidate). / comments
StephenC wrote:
Hi,
In general the options grey out if the add-in doesn’t understand the project type. I think MVC ASP.NET applications produce this, but things like COM+ apps and services will...
AndrewH wrote:
That certainly does sound like an unusually high amount of overhead.
Are you using a virtualized environment? Some VM implementations don't provide a very efficient way of reading the CPU time stamp counter which can have a negative effect on the performance of the profiler. A warning is written to the log file if this is detected.
On XP you should be able to find this in ...
Windows Server 2003 R2 Enterprise Edition SP2, x64, dual-dual-core Xeon w/8GB of RAM. I'm running several VMs on the machine, but they're just idle and not involved.
I did find the log file - no mention of reading the CPU tick counter taking a long time.
Also, are you using .NET 1.1? The profiler API available in that version of .NET is much less efficient than the one introduced into .NET 2.0. For many applications you can work around this by forcing them to run using the .NET 2.0 framework while profiling using an application config file.
.NET 3.5 SP1 (although the program in question is only using .NET 2.0 functionality). / comments
AndrewH wrote:
That certainly does sound like an unusually high amount of overhead.
Are you using a virtualized environment? Some VM implementations don't provide a very efficient way of reading ...