February 6, 2014 at 1:57 pm
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.
February 6, 2014 at 2:01 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 3:34 am
Sorry... misread the Original Post (so my post was not applicable)
February 7, 2014 at 7:50 am
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.
February 7, 2014 at 8:03 am
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 7, 2014 at 8:45 am
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.
February 7, 2014 at 12:51 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply