I am trying to generate tiles on the fly in windows using mod_tile. I have followed the tutorial http://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ on ubuntu and successfully got it running but I want to do the same in windows. Could anyone help me by sketching up a tutorial for the above.
You might try Maperitve as a lightweigt source of rendering tiles as well.
It works on Windows on small and medium areas, and needs no database.
mod_tile effectively has no Windows support. If you don't need it's cache invalidation, you might consider a tile server like MapProxy which has Windows support and can render a Mapnik-based map. You'll find that there is relatively little to no documentation about getting all of the parts to work together on Windows systems.
If you do get it working, Windows is not recommended for large databases so you may find additional limitations there.