Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2005-08-30 : 22:06:51
|
| Hi all, Doesn anyone know about this flag? information about it etc?Thanks |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-08-31 : 01:05:03
|
| The -y startup parameter is used by our support teams to generate a dump file when a specific error occurs. In your case, this is when the 605 error is raised. The dump file contains detailed, internal, technical information about the point at which the error is raised, giving the support team more information about why you're seeing the error in question.Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-31 : 01:19:05
|
| can i use the following code to start it dynamically? rather then restarting the server?Dbcc Dumptrigger('SET', 605)will that have the same effect? and also, does clustered environment pick that up as well, ie. do I need to do anything special for the clustered environment?Thanks |
|
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-08-31 : 13:33:46
|
| Yes, DBCC DUMPTRIGGER will do this dynamically. As far as a cluster, if you use DBCC DUMPTRIGGER, this won't be persisted after a failover. You'll need to modify the appropriate registry keys on both instances of the cluster to ensure that this is persisted in case of a failover.Can I assume that you're doing all of this with the guidance of PSS? Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-08-31 : 21:51:04
|
| yes I am, just wondering does any others running the same flag thats all :)how does that trace works anyway? does it keep listening to SQL and comparing if 605 error occurs? doesn't that means it'll eat up some CPU and memory? |
|
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-08-31 : 23:00:03
|
| "-y605" will catch all 605 errors, "-y602" will catch all 602 errors, etc. No, we don't poll. Internally, we keep a record that this particular error is set to trigger a dump; whenever an error is raised, we compare the error to the list of triggers, and if it's in there, we generate a dump. Should be no added CPU or memory -- okay, well maybe 4-5 cycles and a byte or two :)Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2005-09-01 : 20:39:42
|
| Thanks Ryan, thats help heaps, good to know how this works :)Thanks |
|
|
|
|
|
|
|
|
-y605 flag