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

Server Migration Expand / Collapse
Author
Message
Posted Thursday, February 6, 2014 1:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 23, 2014 10:14 AM
Points: 49, Visits: 55
We are in the process of moving from SQL 7 to SQL 2k, then on to SQL 2008. We have had multiple practice migrations with success moving from 7 to 2k. However I noticed when running sp_who, that the Lock Monitor, Lazy Writer, Log Writer, and Checkpoint Sleep spids are displaying a NULL dbname.
When running sp_who in production, those spids display the database name that I am in. Any help would be appreciated.



Post #1538850
Posted Thursday, February 6, 2014 2:01 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
Is that on the 2000 or the 2008 instance that you see the null database name?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1538854
Posted Friday, February 7, 2014 3:34 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 2,242, Visits: 2,701
Sorry... misread the Original Post (so my post was not applicable)

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1539073
Posted Friday, February 7, 2014 7:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 23, 2014 10:14 AM
Points: 49, Visits: 55
Sorry, that wasn't clear. We are first moving to 2k then 2008. I'm seeing the NULL dbname when running sp_who2 in SQL 2000.


Post #1539192
Posted Friday, February 7, 2014 8:03 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
With the plans to move to 2008 right away, I don't think I would chase this too far. It sounds most like a "feature" with 2000. I haven't seen that happen in 2000, and none of my 2008 instances are exhibiting that kind of behavior.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1539205
Posted Friday, February 7, 2014 8:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 23, 2014 10:14 AM
Points: 49, Visits: 55
I have successfully "practiced" this migration to 2000 5 or 6 times now. But only yesterday noticed that the "practice" 2k server displays NULL, while our production 7 server displays the database name as the dbname when I run sp_who2 in QA in that database.
We've done application testing on this 2k server. But it is not receiving anything close to the traffic that our production server is. So I was guessing that Lock Monitor, Lazy Writer, Log Writer, etc are not being utilized?
Anyway, thanks for your reply.



Post #1539233
Posted Friday, February 7, 2014 12:51 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
They should still display a database name. With no activity on the server, all of my instances still show a database name for those spids.

I think it must be an issue with just the version of 2000 that is installed.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1539360
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse