Activity overview
Latest activity by thejamie
Other pieces of the Red Gate Tools do not currently adhere to FIPS compliance. While Microsoft (http://blogs.technet.com/b/secguide/arc ... ymore.aspx) no longer recommends FIPS compliance, the government requires it. This makes many of the tools used in the Red Gate suite non-compliant and non-workable. As there are no future plans to change government compliance rules, it would be nice to see suggestions here for methods that can be used to monitor sql blocking and locking that approximate the efficiency of SQL Monitor.
For example, a method that provides sys.dm_tran_locks joined to sys.dm_exec_sessions on request_session_id to session_id and left joins the sys.dm_exec_requests cross applied to the session_id's sys.dm_exec_sql_text(sql_handle) might help to provide some of the more serious information. Duration time is also important as is the tracking of job failures. It may all seem simple at the query level, but putting together something as comprehensive as was provided by SQL Monitor is not simple.
So, if there are suggestions, I'm all ears.
Thanks / comments
Other pieces of the Red Gate Tools do not currently adhere to FIPS compliance. While Microsoft (http://blogs.technet.com/b/secguide/arc ... ymore.aspx) no longer recommends FIPS compliance, the go...
We see it on VMWare 5 - most frequently on servers where the RAM exceeds its limit... example: limit is 6 Gig and RAM maxes to 8 GIG and runs an average of 6.7 GIG. (Not sure how it does this - it it only has 6 GIG to play with - anyway, that's what SQL Monitor shows). / comments
We see it on VMWare 5 - most frequently on servers where the RAM exceeds its limit... example: limit is 6 Gig and RAM maxes to 8 GIG and runs an average of 6.7 GIG. (Not sure how it does this - it...
It looks like the seed value depends on the presence of a primary key or not. If for some reason, the Identity key is not a primary key, the process that sets the DBCC CheckIdent (tablename,RESEED,0) does not get processed properly when you are not running the wizard in the table by table section but attempt to run it from the first tab ("Data Sources"). Try running from the tab that says "Tables and Views" and mark the column as an identity column. Otherwise, when not a primary key, the program does not seem to recognize that there is an identity column in the field. Or perhaps the Ignore Identity property is the default but it is over-ridden in the Tables and Views tab section. I can't quite figure out which but I do know that if I run from the Tables and Views, it seems to reset the identity if I check the box on the table that has an identity set. Seems to me to be counter-intuitive. I would think that if the table has an identity set, it should automatically reset that value. / comments
It looks like the seed value depends on the presence of a primary key or not. If for some reason, the Identity key is not a primary key, the process that sets the DBCC CheckIdent (tablename,RESEED...
Noticed that this file became un-registered upon a Repair of Team Explorer 2008. / comments
Noticed that this file became un-registered upon a Repair of Team Explorer 2008.