Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Trace Expand / Collapse
Author
Message
Posted Thursday, September 18, 2008 11:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item SQL Trace






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #572265
Posted Friday, September 19, 2008 7:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:17 AM
Points: 1,250, Visits: 914
It's like the question: What is the color of apples?
a) some are red, some are green
b) some are red, some are yellow
c) partly red, partly green
d) brown

Which answer is 100% correct? None and all of them.
Post #572504
Posted Friday, September 19, 2008 7:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 11:12 PM
Points: 1,263, Visits: 1,081
Can't but agree with you.

"[...] If the disk fills while the database is online, the database remains online, but data cannot be inserted. [...]" (see http://msdn.microsoft.com/en-us/library/ms366198.aspx)

So I guess it's one of those "you're basically right but you haven't got it right" things. ;)
Post #572543
Posted Friday, September 19, 2008 8:08 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:48 AM
Points: 3,963, Visits: 3,644
With a server side trace you can choose the drive to which the trace goes. One of the benefits of doing that is that it won't fill up the drive where the OS resides. I would not choose the drive that the data files are on.
Post #572557
Posted Friday, September 19, 2008 8:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 11:12 PM
Points: 1,263, Visits: 1,081
You are perfectly right and I fully agree.

However, my comment was targeted at the way the question of the day was worded--there is no indication of where the trace would be stored and hence leaving room for actually 'check all that apply' and not just 'one correct' answer. Just as Robert pointed out in the first comment.
Post #572592
Posted Friday, September 19, 2008 8:55 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 3:27 PM
Points: 20,734, Visits: 32,505
Sometimes, I think people think too hard with some of the questions.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #572610
Posted Friday, September 19, 2008 9:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
Even if the disk fills up, data can be interested into a database provided it does not need to grow. Databases typically have free space in them, and if yours don't, I'd argue you aren't managing them well.

The question is about trace, not about databases, and you're making assumptions that don't need to be made. The questions typically are based on a simple situation, not trying to cover all bases.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #572632
Posted Friday, September 19, 2008 10:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 11:12 PM
Points: 1,263, Visits: 1,081
Apologies for my wholistic approach and for quoting MSDN.
Post #572707
Posted Friday, September 19, 2008 10:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
You misquoted MSDN. The quote before that says IF the data files need more space and can't get it, a database engine error is issued. The quote misleads people to believe that SQL Server behaves like Word, Excel, Access, etc. in that every insert requires new disk space.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #572713
Posted Saturday, September 20, 2008 1:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 7, 2009 4:52 AM
Points: 117, Visits: 22
I think question is good and answer is also good.

Out of space not stop your service, but it also not allow to continue your work

Post #572946
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse