Search Results | SQL Server Performance Forums

I have mentioned above...its a web server......

But I am surprised to have page faults/sec:3000 with 2 GB of memory available for utilization....

Thread by: sqlfrenzy, Sep 4, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

I collected perf counter for A duration of 5 hrs on a web serverMemory:Available MB:2200;Page Faults/sec:3000;Pages/sec:7Do i need more ram???

Well...I din't mean that their are no indexes...I said that i have already checked the indexes and they are alright....As far as the link is...

There isn't any indexing issues....I have already done the suggested exercise..However,..the only thing that bothers me is that why the proc runs...

Thread by: sqlfrenzy, Jul 29, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Is it possible to create a rule for every column to start with an upper case letter.

You should also consider the user_seeks and user_scans, One of the reason of the index not being used is the queries for which it was implemented...

Post by: sqlfrenzy, Jul 29, 2009 in forum: SQL Server 2005 General DBA Questions

here you go...Create PROC xspfGetCompanyTxnDetails@CompanyCode xdtAcIdASBEGIN select distinct b.ACCode, 1 ACCountFROM xtftxnHEader a (nolock)join...

Thread by: sqlfrenzy, Jul 29, 2009, 6 replies, in forum: SQL Server 2005 General DBA Questions

There is a stored proc which gives timeout whenever we create new objects in the database, however altering the sp rectifies the issue. The stored...