belle’s sql musings

SQL Server Scalability etc – Free Ebooks

Posted in Ebooks, Resources/References by belle on November 7, 2008

Connection to target machine could not be made in a timely fashion

Posted in Issues/Troubleshooting by belle on November 6, 2008

Problem

Actually the error is (note spelling mistake on fashion):

"Connection to target machine could not be made in a timely fasion"

Scenario

One of our DBAs was testing the SQL cluster failover. After he failed over from Node 1 to Node 2, he can no longer bring up SQL Server Configuration Manager (SSCM). Whenever he tried, he will wait for about 30-40 seconds before he gets an error message : Connection to target machine could not be made in a timely fasion

Resolution

This could have been caused by a whole host of things.

In our case, all we had to do was to restart WMI service:

  1. Start > Run > type services.msc and press Enter
  2. Scroll down to Windows Management Instrumentation, right click, restart
Tagged with:

View or function ‘sys.dm_exec_sessions’ has more column names …

Posted in Issues/Troubleshooting by belle on November 5, 2008

Problem

Agent message code 4502. View or function ‘sys.dm_exec_sessions’ has more column names specified than columns defined.

Scenario

Our replication on our clustered database just started to fail. We were getting the following error:

Agent message code 4502. View or function ‘sys.dm_exec_sessions’ has more column names specified than columns defined.

Ok, this is a weird message. How can sys.dm_exec_sessions have more columns that specified?

We checked the definition:

EXEC sp_helptext 'sys.dm_exec_sessions'

And this is what we got:

CREATE VIEW sys.dm_exec_sessions AS
 SELECT *
 FROM OpenRowset(TABLE SYSSESSIONS)


Ok, we can see how this can be a problem – because of the star (*). Any column change can spell disaster. However, we weren’t very sure why this would cause any problems, because this is not any regular user view. It’s a built in SQL Server DMV.

So we checked out a few things:

SELECT 
 SERVERPROPERTY('ResourceVersion'),
 SERVERPROPERTY('ProductVersion'),
 SERVERPROPERTY('ProductLevel')    -- Service Pack

It turns out the installed Service Packs are not the same in all the nodes.

Resolution

Make sure all nodes in the cluster have the same service pack. Sometimes it’s easy to miss because you have to failover to install the SP.

Tagged with:

Ooohh! Manga Guide to Databases!

Posted in musings by belle on November 2, 2008

I’m an anime/manga/JPop/JDorama junkie. Yup, that’s my other life besides databases. There was a time when I can talk some straight Japanese sentences – because I’ve watched/listened to Japanese stuff so much and so often.

JPop

I play Utada Hikaru, Ayumi Hamasaki, Do As Infinity (Tomiko Van is lead singer) and Maaya Sakamoto quite regularly while I drive. I have most of their CDs. I even used to wait for weeks for Amazon to deliver my JPop CDs because they’re usually not in stock. I’ve also listened to BoA, Hitomi, Amuro Namie, Otsuka Ai, Gackt, TOKIO, Orange Range, Arashi …

JDorama

I watched a lot of the TOP 50 JDoramas listed in JDorama.com. Love Mukodono!, Hana Yori Dango, Hanazakari no Kimitachi e, Love Generation, GTO. Also watched Majo no Jouken (First Love) and Ichi Ritoru no Namida  (1 Liter of Tears) and cried buckets (yeah, I’m a weepy).

Anime/Manga

Anime was what started me with this whole Japanese fascination. The first ever anime that I watched was Rurouni Kenshin (marketed as Samurai X in North America) – all the episodes plus all OVAs – and absolutely loved it. My next set of anime/manga marathons Fruits Basket, Full Metal Panic, Trigun, Cowboy Bebop, Escaflowne, Bleach, Inuyasha (yes, I watched all 167 eps). Also  love Hayao Miyazaki’s works – Nausicaä of the Valley of the Wind, Castle in the Sky, Spirited Away, Pricess Mononoke, Howl’s Moving Castle.

And the point is?

BrentO mentioned on Twitter that there’s a Manga Guide to Databases on Amazon! Isn’t that uber coolness! (For me anyway).

Here’s an excerpt (from Amazon):

Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod’s humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It’s all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems—with the practical magic of databases.

Haha doesn’t that problem sound all too familiar.

The cover is also super cute! Thanks Brent! I am pre-ordering it with JK Rowling’s Tales of Beedle the Bard. So excited.

PS – And if you are looking for good Japanese Tea, you may want to try out Hibiki-an. Great tea! And they deliver it so fast too.

Tagged with: