December 16, 2003 at 9:26 am
Does anyone know of a usage Based costing tool for SQL Server? For instance, we may start charging application owners which hit our DB servers based on the number of times they hit their DB, cpu time, maybe mem usage, etc. My feeling is that we could accomplish the data collection with a server-wide trace. But that would be demanding of resources, and then we would need to import the data in to a database which would become very large, very quickly. So I'm wondering if anyone knows of a third party tool that can be used for this. My concern about a couple of third party tools that I've seen are that they take periodic "samples" of DB usage. But we have soooo many queries that run in under 100ms, that I fear the sampling would not be a reliable measure.
Thanks
December 19, 2003 at 8:00 am
This was removed by the editor as SPAM
December 19, 2003 at 8:18 am
You may try and write queries against sysprocesses, and if you can tie the username to an application you could perhaps sample the data over time, but this isn't foolproof. About the only real way is to do the server-side tracing.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 19, 2003 at 8:29 am
Thanks for the reply Brian. I have been inclined to think the same thing. MS would likely frown on a server-wide trace huh? Probably not a "best practice" to run something like that 24x7..... And that is the kind of reliable information we would need to base our billing structure on.
December 19, 2003 at 8:36 am
There's a performance hit, to be sure, but server-side traces aren't exactly something Microsoft can frown upon. In order to achieve C2 compliance (http://csrc.nist.gov/cc/index.html), detailed auditing must occur. Microsoft did this with SQL Server 2000 by doing server-side tracing. If you were using SQL Server in C2 mode, you'd be running a server-side trace. Pretty detailed one, too.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply