Its around 48 hours,so there is no need to add memory

select db_name(req.database_id) as DBName,con.num_reads as Num_of_reads_by_Connections

,con.num_writes as...

Hi All,

We have a user for a database. Here we need that user should have exec permissions on all stored procedure.

If any new stored procedure created, that user should automatocally...

Change the compatibility mode to 100 and rebuild the indexes and update the stats also,did you ?

First of all check the pages life in memory with the help of mentioned query,if this value less than 300 then you have a memory pressure and you have to...

Sizes of Disk and total database size and database growth rate ?

First of all find the Instance name or if default,you can check this information in the Failover management tool on each SQL Server resources,double click on it and then check...

Install the SQL Server in Cluster Mode and then crosscheck both servers to move services ,then verify services...

@Sumanta

Is there any other port instead of default port 1433,is this your port enabled in SQL Server Database Server,first try the connection with SSMS remotely then go to application

Try to...

Now you're just being pedantic. No, it's a function. The DMV suite is made up of views and functions. Stop trying to be clever, you're not doing yourself any favours...

SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP

CROSS...

@Sumanta

Can you connect SSMS remotely to the instance ?

With that said, I would recommend separating out to at least 5 separate LUNs for management and maintenance purposes. Using separate LUNs for System Databases and error logs, data files,...

the leaf level will be Col1,Col2

the leaf level will be same too as Col2,Col1

for the Leaf Level...

you are connecting as on SSMS

ServerName

or

ServerName\NamedInstance,port

you have to check SSMS from the client PC to Server,You are creating ODBC on the application server,Is this web application or desktop ?

Is Firwall...

think about solution...