Elam's personal Blog

2012,Mar

W

Shrink LDF file in SQL SERVER 2008

in Technical, by Elamparuthi SK

Today i had a problem. when i checked my database LDF file (log) file it’s some where around 25GB. I was trying to shrink the file it’s not possible. Could not able to shrink it from management studio. Found an workaround for that, Here the command for it.

First make the database to SIMPLE Recovery mode and do it.

– Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE [databasename]
SET RECOVERY SIMPLE;
GO
– Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ([log file name], 1);
GO
– Reset the database
ALTER DATABASE [databasename]
SET RECOVERY FULL;
GO

Let me know if any questions

Elam

Tagged with: Sqlserver

2012,Mar

W

Steps to check website and Sql performance

in Technical, Web analytics, by Elamparuthi SK

Hi all,
It’s been very long time since i updated my blog. i am really sorry for that. Well coming to the topic. I was working for one of our entrprise customer. We have web analytics data close to 90GB. we are building another application to displaying the data, so i need to migrate the data to new database.

Intially when we started our migration it takes almost 6 days for one month data. I was wondering what to da. Then i followed the below mention steps and it come down to 3 Hours for one month.

Steps
1 check for each query execution time and also the subtree cost. to get subtree cost include execution steps from the top bar in management studio. When sub tree cost is more sql server uses full 100% cpu time and memory.
2 created the index for each table. while creating index make sure you create index for all where condition combination.
3 use temp table instead of union all query. Because i combine almost 60 table in single query. So instead of union all i used temp table to get the data
4 remove unnessary column in the select statement

Once you follow this points. It will increase the website and sql performance

If any questions just mail me or add a comment

Elam

Tagged with: performance • Sqlserver

2012,Feb

W

Google Analytics Sub Domain Tracking

in GA, Technical, Web analytics, by Elamparuthi SK

Today I had an issue For one of our customer. They had implemented the Google analytics tracking code in their website and they have so many sub domain which they want to track in main domain GA profile Id. They had implemented the Ga code properly and also used _gaq.push(['_setDomainName', '']);, but the problem is the sub domain is still capture as new visit.

when I check the problem it simple they forget to change the subdomains option in the GA profile settings page. it need to be like this

After I changed this also it was not working. because they had added “.”(dot) before the domain. For example if you want to capture the sub domain for elamparuthi.com. we need to set it like this

_gaq.push(['_setDomainName', 'elamparuthi.com']);

Not

_gaq.push(['_setDomainName', '.elamparuthi.com']);

I used GA debugger chrome extension to debug this. it’s really nice tool.You can download it from here

https://chrome.google.com/webstore/detail/jnkmfdileelhofjcijamephohjechhna

Elam

2011,Dec

W

Back again

in Personal, by Elamparuthi SK

Today my friend karthi told me how my blog was useful to him and his team on the project. I was really happy. I stopped updating my blog regularly because of poor response of visitor, today when he said that I was really happy and plan to update my blog on regular basis because I sometime it will help others.

Thanks karthi for positive response and I am starting to write again

Elam

2011,Sep

W

Google Analytics Premium

in Personal, Web analytics, by Elamparuthi SK

Today Google had released the google analytics premium account with the price band of $150,000 per year, i was really shocked on the price band, no idea how many enterprise customer will go for it. In general google analytics premium account we have some nice stuff like

Run sql query aganist your data
Client will owns the data
24/7 support
50 custom variables

Here is the GA account comparison

Because of the data Data ownership may be most of the enterprise company can look to move to GA permium account

Competition is healthy for any industry to grow and progress, but Google appears to be doing this all by itself in the field of web analytics.

will write a another post tomorrow on drawback in free GA account

Regards,
Elam

2011,Sep

W

Are You Addicted to Angry Birds? [INFOGRAPHICs]

in InfoGraphics, by Elamparuthi SK

Nice Infographics on Angry bird game by AYTM.com. I remember when then time angry bird was release i used to play for hours.. Now it’s changed i am playing it frequently, only when i was bored i used to play

Infographic by: AYTM Market Research

Elam

Tagged with: Games

2011,Sep

W

Install Cassandra 0.8.5 in windows 7

in Cassandra, Technical, by Elamparuthi SK

Today i was exploring Nosql option and found Cassandra 0.8.5. you can download the latest version from here. After Download Follow the Below steps

Step 1: Download Java JDK also from here
Step 2 : Install the JDK
Step 3 : Unzip the Cassandra file to some location in your local drive (D:\dev\)
step 4 : Go to “D:\dev\apache-cassandra-0.8.5\conf” . Open the file “cassandra.yaml” in a notepad and change the following :
Change /var/lib/cassandra/data to D:\dev\apache-cassandra-0.8.5\data
Change /var/lib/cassandra/commitlog to D:\dev\apache-cassandra-0.8.5\commitlog
Change /var/lib/cassandra/saved_caches to D:\dev\apache-cassandra-0.8.5\saved_caches

Save the file after that

Step 5: Now for everything to work correctly, you need to update the JAVA_HOME and CASSANDRA_HOME system variables. To this, we need to follow this:

Click the Start Menu
Right click Computer
Click Properties (this opens the Control Panel in the System and Security > System view)
Click Advanced system settings on the left side (this opens the System Properties dialog in the Advanced tab)
Click the Environment Variables button (this opens Environment Variables dialog)
Under the System variablesgroup:
Click New… (This opens the New System Variable dialog)
Input JAVA_HOME for the Variable name text box
Input the path to your java installation for the Variable value text box (I entered C:\Program Files\Java\jdk1.7.0)
Click OK
Under the System variablesgroup:
Click New… (This opens the New System Variable dialog)
Input CASSANDRA_HOME for the Variable name text box
Input the path to your Cassandra extraction for the Variable value text box (I entered D:\dev\apache-cassandra-0.8.5)
Click OK
Click OK
Click OK
Close the Control Panel

Now you should be able to start up and run Cassandra. for that go to “D:\dev\apache-cassandra-0.8.5\bin” and double click on cassandra.bat .

If any clarification, just post a comment

Elam

Tagged with: Cassandra • NOsql

Shrink LDF file in SQL SERVER 2008

Steps to check website and Sql performance

Google Analytics Sub Domain Tracking

Back again

Google Analytics Premium

Are You Addicted to Angry Birds? [INFOGRAPHICs]

Install Cassandra 0.8.5 in windows 7

About Me

Recent Posts

Archives