try these steps for troubleshooting:-
1) try telnet host:port from some remote server from where you can ping this db server (having port 2433)
2) if telnet works, then test...

check firewal as it might be getting blocked there.
Moreover, you must not share your actual ip and user details over web.

Thanks Gail.
But why there is a restriction that the tempdb cant be put completely in memory? The reason is most of the temp objects already residing in the memory...

crazy4sql (9/10/2014)

PRAMANA.DBA (9/10/2014)

I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact scenario...

PRAMANA.DBA (9/10/2014)

I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact scenario ....

I cant open your trace file.

Can you post the text where you would be seeing something like "graph generated"

Thanks again Kevin. Yes, I figured out sp_reset_Connection is normal in trace and shouldn't be concern here. I was looking every difference with double glass :w00t::w00t:

Also checkpoint is enabled. I...

This linked helped me quiet couple of times. Though your issue is solved but you can keep this link somewhere saved in your favourites..

http://sqlserver-help.com/category/forgot-the-sa-password-in-sql-server-2005/

Thanks Kevin, for taking time to look into this.

All dbs...

Yep, changed data file to 200MB and log to 20MB on model (from defaults 3MB/1MB).

Then ran "create database model_test" - files were created as 200MB & 20MB.

That's on 2008R2 SP2....

Thanks for trying Gaz....

Thanks Brian for the reply. I am aware of all those things but the points is "when you create the new user database without any specific configuration, it should get...

Please ignore this duplicate thread as i moved it here http://www.sqlservercentral.com/Forums/Topic1413640-391-1.aspx

thanks for looking

sorry for my Friday hangover, I thought the complain is about log file 🙂

why dont you change your recovery model to "bulk logged" while your ETLs are scheduled?