jump to navigation

TempDB shows available free space in negative March 28, 2013

Posted by msrviking in DB Administration, SQL Server 2008, Uncategorized.
Tags: , , , , , ,
add a comment

I was browsing through one of my favorite forums to replenish my knowledge on SQL Server based on others experiences. While I was doing that, I found this interesting question which made me think “how could that be possible?”.

I am not writing this post as a solution but wanted to share the forum post, and discussions that are happening by other experienced DBAs. Well if that is not enough a Gent has mentioned couple of links in the forum, on why this behavior could be there first in place. As expected, this was a bug in SQL Server 2008 SP1 and fixed in SQL Server 2012, but I am not sure if folks are having issues with SQL Server 2008 R2 though.

Here are those links that you might want to refer in case you have issues. One link explains the probable reason of the behavior, and the other one is a connect item.

http://blogs.msdn.com/b/ialonso/archive/2012/10/08/inaccurate-values-for-currently-allocated-space-and-available-free-space-in-the-shrink-file-dialog-for-tempdb-only.aspx
http://connect.microsoft.com/SQLServer/feedback/details/518309/tempdb-log-file-showing-free-available-space-in-negative

I couldn’t and didn’t replicate the issue if at all I had to, because there is documented information on this. BTW, I haven’t seen any response on this question post by the person who had asked. So I am presuming this is the reason and probably could be fixed or is fixed.

Cheers and Thanks.

Advertisements

Why am I not able to connect to SQL Server 2008? May 21, 2009

Posted by msrviking in SQL Server 2008.
add a comment

Although I am little slow and late to the party of testing SQL Server 2008 features, I realized “Its better late than never!”.

Well, with this I hit into one of the first issues where in I had to connect to a SQL Server 2008 running on a remote (remote in here means a different box), and I was not able to. I was getting this error “Named Pipes Provider, error: 40 – Could not open a connection to SQL Server” constantly.  I was little confused and I went into analytical mode to understand the problem. Here is a quick list I did to ensure that I logon to this SQL Server 2008 instance.

1. Checked if I was able to ping the ip address of the host.

2. Check if SQL Server service is up and running. I usually don’t let any services start off automatically while I do installation, and I thought I had some company.

3. Tried checking if the option of “Allow Remote Connections” was ON. Well, here is the first hit I received where in I was searching for SAC (Surface Area Configuration Tool). In SQL Server 2008 this is discontinued, and to my surprise I couldn’t find pleasing reason to stop this tool. Now one will find it by Right Click Instance -> Click Facets -> New window with dropdown box of options where in one should choose Suraface Area Configuration. I was not comfortable using it, because I don’t have an exclusive tool to use this, instead everything looks pushed into one corner (“Facet”).  Now that is a different reason to grumble about.

To find out what is wrong while trying to connect I checked the configurations options under SAC and found everything looks good and set to go. But, what on the earth is happening that the instance is not letting me in from my machine?

Also here is a link which talks more about – Where is the SAC tool?

5. Checked the Windows Firewall status.

4. Checked the Configuration Manager to see the protocols that are enabled and disabled. And there it was, both the named pipes and TCP/IP were disabled. As soon as I enabled these protocols (its not necessary you will want to enable both to connect) I was able to get through the connectivity and I was set to start using the new instance.

There is an interesting blog entry that talks exclusively about the connectivity issues which you guys may want to look and keep it in handy.

Okay moral of the story or this exercise. I told myself its just common sense, that you couldn’t go and check the protocols instead you were running through many steps and spending away valuable time. Thank God, this didn’t happen in prod environment! Silly me, if I had to do these in prod boxes ;).  Sometimes, thinking at 20,000 ft level (which I tend to do often these days), I am forgetting my basics.

Happy reading, and cheers!

Comply else you are in danger! January 20, 2009

Posted by msrviking in SQL Server 2008.
add a comment

Hi Guys,

It has been quite sometime I had posted something new. Well, I was going through my feed reader (FeedDemon – I love this tool from NewsGator) and learnt from one of the blog entries about the new stuff on SQL Server 2008 which I thought I should share with you all. You know what, SQL Server 2008 has a compliance website where you could use bunch of stuff like securing your system by database encryption, policy based management of the SQL instances, breaking the roles, responsibilities and duties. Why don’t you hear more from the experts of MSFT on this topic over here. I always believed even though there are lot of stuff coming out for SQL Server 2008, but one could use the rules on SQL Server 2005 if you haven’t migrated one. So go through it and have good reading and let me know your experiences and thoughts.

SQL Server 2008 at its best November 26, 2008

Posted by msrviking in SQL Server 2008.
add a comment

Guys, I was reading through my favorite blog rolls and I happen to get into this link. Very interesting stuff on how SQL Server 2008 is performing with billions of TSQL statements. I am amazed with this guy called “SQL Server”. Kudos to SQL Server team for bringing us until here! I remember how I used to struggle to fix things in SQL Server 6.5 10 years ago and today, well, I don’t have anything to talk about because the product talks for itself.

Enjoy!

SQL Server Virutalization November 17, 2008

Posted by msrviking in SQL Server 2008.
add a comment

I have been fascinated with the concept of SQL Server virtualization for quite sometime. All the while, I had the belief that virtualization is for consolidation of sprawling SQL Servers in different environments. Although, it (virtualization) does help to consolidate, but there are other benefits for doing this. I happen to visit this website Virutalization, by MS team and this site gives information on How to Virtualize, How best you could utilize your environments  hardware resources, and many others.

My advise would to read the stuff in this website and empower yourself with latest happening of IT – Virtualization.

Happy reading!

SQL Server 2008 is touching new heights November 3, 2008

Posted by msrviking in SQL Server 2008.
add a comment

Read this for yourself, and feel the new heights of SQL Server 2008 on what it does with Siebel CRM.

Amazing stuff! November 3, 2008

Posted by msrviking in SQL Server 2008, Technical Documentation.
add a comment

Guys, I couldn’t hold sharing this information with you all. I was running through my favorite list favorite blog rolls and I happen to learn that PDC 2008 has just concluded. There are dozens of sessions taken by product experts, industry stalwarts, and who not…I have made myself a lucky guy by downloading few of my interesting subject’s session recordings. Why don’t you too get your own over here… Remember, the recordings are in 100+ MB sizes (of course there are less than 100 too), but worthy enough, although I couldn’t attend in person.

I am going to start listening on all these soon, and shall share my learning’s.

What can SQL Server 2008 do, for BI? October 8, 2008

Posted by msrviking in SQL Server 2008.
add a comment

Read thro’ SQL Server 2008 performs 1 trillion row query in seconds at BI Conference and also you will love hearing what did SQL Server 2008 do and on next versions of SQL Server and its capabilities.

Enjoy!

SQL Server 2008 being marketed aggressively October 1, 2008

Posted by msrviking in SQL Server 2008.
add a comment

I have never seen SQL Server being marketed aggressively before being released into the market full fledged. It sounds to me like Bollywood Movies aggressive  advertisement strategy, where the movie songs, trailors are advertised across all media channels. And there are movies that flop in the box office and are mega – hit.

I being an ardent lover of SQL Server I am sure and I have confidence that this is going to be a mega – hit in the IT (box office) industry.

Visit the link for experiencing the movie "SQL Server 2008".

Enjoy the movie!

SQL Server 2008 will have DATAllergo techology September 17, 2008

Posted by msrviking in SQL Server 2008.
add a comment

Here is a press release by Microsoft on 9/17 on DATAllergo technology being used in SQL Server 2008. Today there are no bounds for my happiness on the progress that SQL Server has made since the time I had worked on (as far as my memory goes I worked on Sybase 11.x, and SQL Server 6.5).

A quick information on what MS had to say about this,

"Microsoft Corp. continues to rapidly expand the capabilities of its
data platform and is already revealing product road map details
following the acquisition of DATAllegro Inc., a provider of
large-volume, high-performance data warehouse appliances. As part of
its focus on helping organizations manage and access even the largest
quantities of data, Microsoft will offer a new solution based on
DATAllegro’s technology that extends Microsoft SQL Server to scale into
hundreds of terabytes of data. The company will begin giving customers
and partners early access to the combined solution through community
technology previews (CTPs) within the next 12 months, with full product
availability scheduled for the first half of calendar year 2010."

A quick information on what could DATAllergo could do for SQL Server 2008,

"Some info from their website: DATAllegro v3 performs table scans between 0.5TB/minute and 10.5TB/minute. DATAllegro v3 offers new capabilities to handle complex workloads that are a mixture of near real-time loads, long analytical queries and short quick-hit queries. Improved workload management gives queries with low workloads higher priority, reducing the overall workload on the server. DATAllegro also provides a comprehensive architecture with a high-speed loader performing loads at rate of over 1TB/hour. The loading server or landing zone within the high-speed appliance network is used to provide a loading services with a minimal impact to queries being run."

All the best SQL Server!