I am very pleased to join this forum

I am new to SQL programming , I am facing a challenge our sql server database entry is crossing 1lakh per day,so connection becomes slow....

For this how can i handle the situation!!
our databases deals with leads and hits in affiliate website..

Thanks in advance.