Hi
Im using profiler to get information about query on the server here but i cant seem to be able to get the memory usage of a query. I can acess the cpu, I/O and duration but i cant seem to be able to get that last info i need.
Is there any way for me to obtain it trough profiler?
Not through profiler nosqlHow should I know if I need to add new processor to my Server?
During Submission of our Records every 24th day of the month the cpu usage of the server is steady 100% can you please help me what alternative can I do? or how can i check if need to add new processor. 
Please help me guys.
thanks
Any sustained CPU usage exceeding 90% indicates a need for more 'processing' power.
If this ONLY occurs on the 24th day of the month, and the remainder of the time CPU utilization is lower, you have a couple of options.
Change the workload on the 24th, spread it out into several smaller 'batches'
OR
Get additional processor power (add one or more CPU(s)).
|||You should also try to investigate what part of your workload is using the most CPU and see if you can do something about it. For example, you might be missing an index for a frequently run query that is causing more CPU pressure (among other things).
-- Get the most CPU intensive queries
SET NOCOUNT ON;
DECLARE @.SpID smallint
DECLARE spID_Cursor CURSOR
FORWARD_ONLY READ_ONLY FOR
SELECT TOP 25 spid
FROM master..sysprocesses
WHERE status = 'runnable'
AND spid > 50 -- Eliminate system SPIDs
AND spid <> 102 -- Replace with your SPID
ORDER BY CPU DESC
OPEN spID_Cursor
FETCH NEXT FROM spID_Cursor
INTO @.spID
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'Spid #: ' + STR(@.spID)
EXEC ('DBCC INPUTBUFFER (' + @.spID + ')')
FETCH NEXT FROM spID_Cursor
INTO @.spID
END
-- Close and deallocate the cursor
CLOSE spID_Cursor
DEALLOCATE spID_Cursor
-- Get Top 50 executed SP's ordered by avg worker time
SELECT TOP 50 qt.text AS 'SP Name', qs.execution_count AS 'Execution Count', ISNULL(qs.total_elapsed_time/qs.execution_count, 0) AS 'AvgElapsedTime',
qs.total_worker_time/qs.execution_count AS 'AvgWorkerTime',
qs.total_worker_time AS 'TotalWorkerTime',
qs.max_logical_reads, qs.max_logical_writes, qs.creation_time,
DATEDIFF(Minute, qs.creation_time, GetDate()) AS Age,
ISNULL(qs.execution_count/DATEDIFF(Second, qs.creation_time, GetDate()), 0) AS 'Calls/Second'
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
--WHERE qt.dbid = 5 -- Filter by database
ORDER BY qs.total_worker_time/qs.execution_count DESC
-- Missing Indexes
SELECT user_seeks * avg_total_user_cost * (avg_user_impact * 0.01) AS index_advantage,
migs.*, mid.*
FROM sys.dm_db_missing_index_group_stats AS migs
INNER JOIN sys.dm_db_missing_index_groups AS mig
ON migs.group_handle = mig.index_group_handle
INNER JOIN sys.dm_db_missing_index_details AS mid
ON mig.index_handle = mid.index_handle
--WHERE statement = '[ngservices].[dbo].[UserFeedUnreadCountRollup]' -- Specify one table
ORDER BY index_advantage DESC;
|||Yeah, I guest we need a new server after all . . . this is really makes me difficult . . thanks for the INFO 
Hey, I might try to use this script . . . I'll keep you update . . . thanks a lot
I have made a new dimension and setup the reference in dimension usage. Every time I process the cube i got the following message
Error 1 OLE DB error: OLE DB or ODBC error: Invalid column name 'PReference'.; 42S22. 0 0
The value in this column is 0,1 or 2. I have set the value in all rows to 1 and still get the same error.
I have tried to create a new column - updated value to 1 and refreshed the datasource and changed the dimension and dimension usage and I still got the same error processing the cube.
I have tried to use another integer field in dimension usage and this works fine.
Maybe it is something on the table - i have tried almost all but I can't solve this problem.
Leo Pedersen
The error message "Invalid column name 'PReference'" is saying that an invalid column name was specified in the SQL query that AS generated. Run Profiler on the AS server and capture the SQL query. It should point you to the problem.quote:
> Hi,
> We have an application accessing an SQL Database. The problem is that due
quote:|||No.
> a flaw in design, when queries are submitted we get 100% cpu usage on the
> server. Is there any way to limit processing power for specific access?
> Thanks
> Nich
>
quote:
> Hi,
> We have an application accessing an SQL Database. The problem is that due
quote:|||Hi Hari,
> a flaw in design, when queries are submitted we get 100% cpu usage on the
> server. Is there any way to limit processing power for specific access?
> Thanks
> Nich
>
quote:
> Hi,
> Try to identify the SQL's which is doing a table scan. Then based on the
> where condition in the select statement
> create useful indexes, this will definitely reduce the Disk reads, which
quote:|||if you have a multiprocessor machine, you could limit sql server to a subset
> turn reduces the CPU usage.
> Thanks
> Hari
> MCDBA
> "Microsoft News - SQL Server" <naquilina@.gfi.com> wrote in message
> news:O5yHsJP5DHA.1040@.TK2MSFTNGP10.phx.gbl...
due[QUOTE]
> to
the[QUOTE]
>
