Viewing 15 posts - 1 through 15 (of 491 total)
OBJECT_NAME counter_name cntr_value
SQLServer:Buffer Manager Page life expectancy 172320
SQLServer:Buffer Node Page life expectancy 172320
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...
July 13, 2011 at 1:03 am
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...
July 12, 2011 at 2:17 am
Change the compatibility mode to 100 and rebuild the indexes and update the stats also,did you ?
July 12, 2011 at 1:55 am
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...
July 12, 2011 at 1:51 am
Sizes of Disk and total database size and database growth rate ?
July 12, 2011 at 1:39 am
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...
July 12, 2011 at 1:36 am
Could you please suggest what all should be considered while making this change
Install the SQL Server in Cluster Mode and then crosscheck both servers to move services ,then verify services...
July 6, 2011 at 3:46 am
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...
July 5, 2011 at 12:54 am
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...
July 5, 2011 at 12:22 am
I beg to differ. The DBA exams do cover the DMVs, especially the session-related ones. Hence if you passed that exams you should know these DMVs.
SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP
CROSS...
July 4, 2011 at 10:28 pm
Can you connect SSMS remotely to the instance ?
July 4, 2011 at 6:09 am
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,...
July 4, 2011 at 6:05 am
CREATE NONCLUSTERED INDEX idx_1 ON T (Col1, Col2)
the leaf level will be Col1,Col2
CREATE NONCLUSTERED INDEX idx_1 ON T (Col2)
the leaf level will be same too as Col2,Col1
for the Leaf Level...
July 4, 2011 at 5:23 am
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...
July 4, 2011 at 3:14 am
Again, all we are stating is that the advice you provided was wrong. Your code used depreciated features that may not work in future versions of SQL Server.
think about solution...
July 4, 2011 at 2:31 am
Viewing 15 posts - 1 through 15 (of 491 total)