Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with performance
Search options not deleted
user 154418
An evaluation of whether a system works well enough to be fit for purpose. Normally performance refers to the speed with which a system completes an operation or set of operations over time.
1
vote
High usage of CPU Without use
Here is the query to get top 5 queries consuming most cpu,with their execution plan.
SELECT TOP 5 total_worker_time/execution_count AS [Avg CPU Time],
Plan_handle, query_plan
FROM sys.dm_exec_qu …
- 362
-3
votes
Non-sequential Primary Key performance in PostgreSQL 9.3
You can create a sequence and make it global. Like below:
create sequence seq;
Create a view on this sequence:
CREATE VIEW seq_view AS SELECT nextval(‘seq’) as a;
Now, We will be using a foreig …
- 362
1
vote
Raid 1 or Raid 1+0 for SQL Server Architecture
RAID 10 provides the performance benefits of disk striping with the disk redundancy of mirroring. … RAID 10 provides the highest read-and-write performance of any one of the other RAID levels, but at the expense of using two times as many disks. …
- 362
2
votes
1
answer
932
views
Postgres backup PITR strategies [closed]
Please let me know which option should be better or any other option if anybody has then suggest that option as well.Also, let me know if any performance impact can happen with a database in case we have …
- 362