Home / user-4863

AgileJon's questions

Martin Hope
AgileJon
Asked: 2014-04-24 10:08:48 +0800 CST
  • 30

I am running an ASP.NET MVC webapp in IIS 8.0. My application needs to be warmed up before taking requests. We already have a process to warm up the application automatically when we deploy new code. However, we are seeing periodic App Pool Recycle events that are resulting in the app not being warmed up.

Is there a best practice for detecting an app pool recycle event and executing a script or some code?

asp.net-mvc
Martin Hope
AgileJon
Asked: 2009-12-24 07:17:51 +0800 CST
  • 1

I've got a table in my SQL Server 2005 database with two indices that are heavily fragmented (33.3% and 85.7%). The table looks like the following:

CREATE TABLE [dbo].[Seasons](
   [SeasonID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
   [TeamID] [bigint] NOT NULL,
   [Year] [smallint] NOT NULL,
   [Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Seasons] PRIMARY KEY CLUSTERED 
( [SeasonID] ASC )

The other index is on the TeamID column. When I attempt to rebuild the indices in management studio it tells me 'success' on each one. But, when I view the fragmentation again nothing has changed. The table only has 2300 rows in it. Not sure if this is relevant, but I also noticed that it takes a LONG time (on the order of 30 seconds) to pull up the fragmentation info when I right-click an index, choose properties, and then select the Fragmentation page.

Other indices in the DB rebuild without a problem.

Any idea why I can't actually rebuild these indices? Any idea why it takes sooo long to pull up the fragmentation information? Thanks!

sql-server
Martin Hope
AgileJon
Asked: 2009-08-26 12:42:07 +0800 CST
  • 0

I am using SQL Server 2005 Standard Edition. I have a primary DB and a read-only replica with Transaction replication configured. My understanding is that with transactional replication that the 'INSERT' statement would not return until

  1. The row is inserted into the primary, and
  2. The row was completely replicated to the replica DB

However, I am experiencing a problem where we do an insert, it returns (I know this because I am using an identity PK column, and I have my ID value). I then run a SELECT statement on the replica DB where I attempt to lookup the row by ID, but it does not yet exist. If I wait a few more seconds everything is fine. Is my understanding of transactional replication off? Is there a way to make it work the way I am thinking?

sql-server replication
Martin Hope
AgileJon
Asked: 2009-07-17 10:55:31 +0800 CST
  • 0

I'm attempting to intall the CTP3 bits on a medium CPU 32-bit EC2 instance running Windows Server 2003 Datacenter Edition. I am using SQL server to store my configuration (on a separate machine). I am able to enter the DB connection string and I see that the database tables are created and the connection test is successful. I set it to be a small (1-4) instance and modified the cache size to be 256. When I click 'Save and Close' it appears to be working and then displays an error message "Error: No such host is known". At that point, the installer seems to be done. I can tweak values but 'Save and Close' no longer does anything. Note, I also did try using a network share for my configuration location instead of the DB, and received the same error message.

Any help would be greatly appreciated, thanks!

amazon-ec2